ADO.NET SqlClient connection string - Data Source syntax

Question

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.

check www.connectionstrings.com

Jhonny D. Cano -Leftware-
– Jhonny D. Cano -Leftware-

2009-12-30 18:17:39 +00:00
Commented Dec 30, 2009 at 18:17 — Jhonny D. Cano -Leftware-
– Jhonny D. Cano -Leftware-, Commented Dec 30, 2009 at 18:17

Gabriel McAdams · Accepted Answer · 2009-12-30 18:20:10Z

3

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

answered Dec 30, 2009 at 18:20

Gabriel McAdams

58.5k12 gold badges67 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DOK · Accepted Answer · 2009-12-30 18:19:42Z

0

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

answered Dec 30, 2009 at 18:19

DOK

32.8k8 gold badges64 silver badges93 bronze badges

Collectives™ on Stack Overflow

ADO.NET SqlClient connection string - Data Source syntax

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related