How to build connect string to the second instance of SQL Server \ database

K

Krishna

Hi

Could some one tell me how to build connect string to the
second instance of SQL Server \ database on the same
machine using ASP.NET environment

Is it

"Data Source='server name\SQL server instance name',
Initial Catalog='datanase name' Integrated
Security='sspi" ?

or some thing else

Thanks
Krishna
 
S

S. Justin Gengo

Krishna,

You've got it.

SqlServerName\InstanceName

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

Free code library at:
www.aboutfortunate.com

"Out of chaos comes order."
Nietzche
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,904
Latest member
HealthyVisionsCBDPrice

Latest Threads

Top