Have Geek Brain

ADO.Net SQL Server Connection String

I am confused about the ADO.Net connection string format when connecting to a non-default SQL Cluster instance. I have searched but find various samples, could anyone please tell me what is the correct format please (if I know the virtual server name and instance name)? I am using a trusted connection.

thanks in advance george

0


a source to share


5 answers


ServerName \ InstanceName? Use double \ when processing strings in C #



+2


a source


See http://www.connectionstrings.com/ for a great site for creating DB connection strings.



+3


a source


The following website provides you with many different connection strings. I believe the following:

http://www.connectionstrings.com/sql-server-2005#1

This is also a duplicate of the connection string to the SQL Server cluster

+1


a source


If you can connect to it using visual studio then connection properties should give you using connectionstring vs .net. Using this connection string might help.

0


a source


If you want a quick and easy way to try different connection strings, I suggest DatabaseTester (disclaimer - I wrote it). This is a free and very easy way to test. And I agree with other posts above, for figuring out string relationships, ConnectionStrings.com is your best friend.

0


a source






More articles:


All Articles