You can specify the following connectivity properties for your SQL Server database:
| Property | Description |
|---|---|
| Host | Specifies the hostname or IP address of the database server. |
| Port | The TCP port of the primary database server that is listening for
connections to the Microsoft SQL Server database.
The default is 1433. |
| User | Specifies the case-insensitive user name used to connect to your Microsoft SQL Server database. |
| Password | Specifies a case-insensitive password used to connect to your Microsoft SQL Server database. |
| Database | Specifies either the IP address or the server name, if your network supports named servers, of the primary database server. |
| URL | Defines the URL format used to connect to your database. |
You can define name/value pairs to provide additional configuration properties to your database. See your vendor's documentation for more information.
| Property | Description |
|---|---|
| Maximum Pool Size | Determines the maximum number of connections that can be created within the connection pool. |
| Maximum Connections Per User | Determines the maximum number of connections that can be created per user. |
| Connection Idle Time (minutes) | Specifies the maximum time, in minutes, that a database connection can remain idle before it is closed automatically. |
| Minimum Pool Size | Determines the minimum number of connections that can be created within a connection pool. |
| Maximum Opened Cursors | Determines the maximum number of cursors that can be opened at one time. |