By default the SQL Server connector will retrieve metadata for all Tables & Views the connection user has access to.
In addition if stored procedures are enabled on the SQL connector, then timeouts may occur especially for applications that utilize a large number of stored procedures such as Dynamics GP or SAP.
 

A SQL Server database with a large number of Tables, Views or Stored Procedures may cause a timeout when retrieving metadata

The resolution is to reduce the amount of metadata that needs to be retrieved:

Option 1: Use the SQL connector's Additional Parameters and Object Filters to limit the objects and metadata retrieved by the connection. For Example:

Additional Parameters  = AllowTables=true; AllowSprocs=false; AllowViews=false
Object Filters = Tables=*Account*;*Contacts*

Option 2: Create a user in SQL Server that has permissions to a limited number of objects.

Specify that user in the SQL connection. The connector will only retrieve metadata for objects the connection user has access to.

For more information see the TIBCO Scribe® Online Connector For Microsoft SQL Server guide in the Help.