SQL Server Connection Strings
SQL Server Connection Strings
Connection String Key Values
Key |
Description/Notes |
Valid Values |
Server Name |
Name of server containing the database.
|
Valid server name. |
Database Name
|
Name of database containing the data tables you will read or write.
|
Valid database name. |
Application Name (optional) |
Name that identifies the application making the connection. |
String value. |
Workstation Id (optional) |
Name that identifies the machine making the connection. |
String value. |
Username
|
Only needed if not using Integrated Security.
|
String value. |
Password
|
Only needed if not using Integrated Security.
|
String value. |
Use Integrated Security
|
Check this option to allow system to use your network credentials when logging onto the database.
|
Checked = true Unchecked = false |
Use Async Processing
|
Setting this option might enable results to be returned faster. |
Checked = true Unchecked = false
|