interview

Home / DeveloperSection / Interviews / please help me i want to create a connection string that can be use with multiple sql server means it will accept the server name of the machine

Ask Question

please help me i want to create a connection string that can be use with multiple sql server means it will accept the server name of the machine

Anil Yadav266415-Feb-2012
asp.netasp.net 
Updated on 21-Sep-2020
Anil Yadav

Anil Yadav

Follow
I have just started my career as a developer asp.net developer

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

16-Feb-2012
Hi Anil,
You can run multiple instances of SQL Server on the same host using the named instance feature. If your target database instance is a named instance, SqlClient will also need to know the instance name or instance port number. The instance name can be specified by appending a backslash and instance name to the Data Source value:

Data Source=SQLSERVERNAME.MYDOMAIN.COM\MYINSTANCE;Integrated Security=SSPI;Initial Catalog=MyDatabase

For more details check this link...
http://weblogs.sqlteam.com/dang/archive/2011/07/10/sql-server-connection-strings.aspx



Liked By