The Advanced settings contain advanced parameters that are used for the SQL database connection string.
Settings
| Option | Description |
|---|---|
| Use SQL Server encrypted connection | Use SSL to encrypt communication with the database. |
| Trust server certificate | Always trust the server certificate. |
| Failover partner | The name of the failover partner server if database mirroring is configured. This is used only for the initial connection as the principal server will return a name which will replace the configured value when different. |
| Connection minimum pool size | The minimum number of connections that are allowed in the pool. |
| Connection maximum pool size | The maximum number of connections that are allowed in the pool. |
| Connection retry count | Controls the number of reconnection attempts after the client identifies an idle connection failure. Valid values are 0 to 255. The default is 1 and 0 means do not attempt to reconnect. |
| Connection retry interval | Specifies the time between each connection retry attempt (ConnectRetryCount). Valid values are 1 to 60 seconds (the default is 10), applied after the first reconnection attempt. When a broken connection is detected, the client immediately attempts to reconnect; this is the first reconnection attempt and only occurs if ConnectRetryCount is greater than 0. If the first reconnection attempt fails and ConnectRetryCount is greater than 1, the client waits ConnectRetryInterval to try the second and subsequent reconnection attempts. |
| Connection timeout | The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. |
More settings
The More settings button, in the Advanced settings section, contains more advanced parameters that can be edited to replace a missing parameter. Double click a Setting name to enter edit mode.
