Page History
...
The Connection String Generator offers over 40 editable connection string options to build your custom string. The following table includes the basic connection string options available when using the Connection String Generator tool.
| Property | Description |
|---|---|
| SQL Server | Required. Specifies the name or network address of the SQL Server instance to which you want to connect. To specify a local unnamed instance, type "(local)". |
| TCP/IP Port | Required when the target SQL Server does not use the default port of 1433. Specifies the port on which the SQL Server listens. |
| Database or Initial Catalog | Specifies the database or catalog to which you want to connect. |
| Application Name | Specifies the name of the application that you want to connect to the SQL Server instance. Use this option to identify your application in audit trails. If you are using ADO and do not specify an application name, Connection String Generator uses the default string '.NET SQLCLient Data Provider'. |
| Connection Timeout | Specifies the amount of time in seconds you want to wait before the connection times out due to a failure or error. This option is set to 15 seconds by default. |
| Encrypt Data | Enables SLL encryption for all data sent between client and server. This option requires a certificate installed at the server. |
| Connect Using | Specifies the credentials to use when connecting to the SQL Server instance. Choosing Windows authentication use the current Windows login credentials whereas choosing SQL authentication lets you specify a SQL login and password. |
The following table includes the connection pooling options available when using the Connection String Generator tool.
| Property | Description |
|---|---|
| Use Connection Pooling | Enables connection pooling. When enabled, the connection is drawn from the pool or created and added to the pool. This option is enabled by default. |
| Max Pool Size | Specifies the maximum number of connections available in the connection pool. This option is set to 100 by default. |
| Min Pool Size | Specifies the minimum number of connections available in the connection pool. This option is set to 0 by default. |
| Connection Lifetime | Specifies the lifetime of a connection in seconds. This option indicates whether the connection is destroyed or kept alive when returned to the connection pool. Specifying 0 gives the connection the maximum allowed timeout. |
| Reset Database Connection | Specifies whether the connection is reset when drawn from the connection pool. |
...
The following table includes the client network library options available when using the Connection String Generator.
...
To generate a connection string:
- Open the Idera IDERA SQL Admin Toolset Launchpad, and then click Connection String.
- Specify the SQL Server instance to which you want to connect. This field is the only required field to generate a connection string.
- Specify any other options you want to include in your string, such as the default database, alternate credentials, or your application name.
- Click Test Connection to ensure you specified the correct options for the connection string.
- If the test connection is successful, copy the connection string to paste into your own code by clicking Copy to Clipboard.
...
SQL Admin Toolset delivers 24 essential administration tools. Learn more > >
...