The dbo.ConnParameters table allows you to set connection parameters universally and/or for individual instances, for individual collections.
For example, you could configure the Collector.SysObjects collection to use either the SQL Server Agent account to connect (by denoting UserName=’SSPI’ and PWord=’SSPI’), or another specific account.
You can also configure the connection timeout, packet size, and other connection options available to the .NET class “System.Data.SqlClient.SQLConnection” (see also the ConnectionString Property).
| Name | Type | Description |
| ID | bigint | Primary key row identifier. |
| InstanceID | bigint | Instance ID of the SQL Server instance, as defined in dbo.Servers. InstanceID = 0 applies to all managed servers. |
| CollectionName | varchar | The name of the data collector, e.g., Collector.SysObjects. |
| UserName | varchar | The user name used to connect to the instance. Default: If UserName = SSPI and Pword = SSPI, the collection will use the SQL Agent account to connect. |
| Pword | varchar | The password used to connect to the instance. |
| ConnTimeout | int | The time to wait (in seconds) while trying to establish a connection before stopping and throwing an error. |
| PacketSize | int | The size (in bytes) of network packets used to communicate with SQL. |
| AppName | varchar | This is the name of the application that will show up in the OS processes list. |
| Asynch | bit | When true, this enables asynchronous operation support. |
| AppIntent | varchar | Declares the application workload type when connecting to a server. Valid values: NULL ReadOnly ReadWrite |
| Authentication | Varchar | The authentication method used for Connecting to SQL Database By Using Azure Active Directory Authentication. Valid values are: NULL Active Directory Integrated Active Directory Password Sql Password |
| ConnRetryCT | tinyint | The number of reconnection attempts. Default: 1. Valid values are 0 to 255. 0 means do not attempt to reconnect. |
| ConnRetryInterval | tinyint | Specifies the time between each connection retry attempt. Default: 10. Valid values are 1 to 60. |
| Encrypt | Bit | When true, SQL Server uses SSL encryption for all data sent between the client and server if the server has a certificate installed. |
| MultiSubnetFailover | Bit | configures SqlClient to provide faster detection of and connection to the (currently) active server. See ConnectionString Property for more information. |
| TrustServerCert | Bit | When set to true, SSL is used to encrypt the channel when bypassing walking the certificate chain to validate trust. If TrustServerCert is 1 and Encrypt is 0, the channel is not encrypted. |
| IsActive | bit | Determines whether the current row is valid (active), and should be used. |
| Comment | varchar | For your reference only. You can label each row with a short description and/or purpose. |