Connection String Parameters for SqlConnection January 3rd, 2010
Here are the basic parameters for the SQL Server data provider connection string.And this will be easily used to look up for developers.
SQL Server Data Provider Connection String Parameters
| Name | Alias | Default Value | Allowed Values | Description |
|---|---|---|---|---|
| Application Name | .NET SqlClient Data Provider | Any string | Name of application | |
| AttachDBFileName | extended properties, Initial File Name | None | Any path | Full path of an attachable database file |
| Connect Timeout | Connection Timeout | 15 | 0-32767 | Seconds to wait to connect |
| Data Source | Server, Address, Addr, Network Address | None | Server name or network address | Name of the target SQL Server instance |
| Encrypt | false | true,false,yes,no | Whether to use SLL encryption | |
| Initial Catalog | Database | None | Any database that exists on the server | Database name |
| Integrated Security | Trusted_Connection | false | true,false,yes,no,sspi | Authentication mode |
| Network Library | Net | dbmssocn | dbnmpntw, dbmsrpcn, dbmsadsn, dbmsgnet, dbmslpcn, dbmsspxn, dbmssocn | Network.dll |
| Packet Size | 8192 | Multiple of 512 | Network packet size in bytes | |
| Password | PWD | None | Any string | Password if not using Windows Authentication |
| Persist Security Info | false | true,false,yes,no | Whether sensitive information should be passed back after connecting | |
| User ID | UID | None | Any string | User name if not using Windows Authentication |
| Workstation ID | Local computer name | Any string | Workstation connecting to SQL Server |