SQL Server Connection Strings

image\SQLServerConnectionStrings.gif

 

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