views:

318

answers:

3

Is there any official write-up what forms can Data Source field take in sql server connection string? I'm aware of following forms:

SERVER
SERVER\Instance
tcp:SERVER,port
nb:SERVER
nb:SERVER\Instance

are there more forms?

EDIT: The essence of this exercise is not to construct a connection string. I am trying to parse existing connection string, and I want to know all the forms it could take. I appreciate everybody who pointed me to www.connectionstrings.com, and this site is useful enough, but it clearly does not have all the information. For example, it will not specify that it is possible to use construct like "Data Source=tcp:SERVER,10000" to specify that TCP must be used for this datasource on port 10000.

A: 

This website has more than you could possibly ever want to know about connection strings for SQL Server and many other databases:

Connection strings for SQL Server 2005

DOK
+3  A: 

check this website for all connection string questions: http://www.connectionstrings.com

Gabriel McAdams
Please remember to accept this answer if you found it to be useful.
Gabriel McAdams
A: 

Connection String Builders

CodeToGlory

related questions