By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,510 Members | 1,810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,510 IT Pros & Developers. It's quick & easy.

Connection String

P: 153
Suppose i have got one statis Ip address <a.b.c.d> and i have configured my PC to this static ip.
The name of my PC is "akshay".
And i have got 3 names instances of Sqlserver in my PC
"server1","server2" and "server3" and one default instance "SQLSERVER"

Also, if i create one application to access "server1" from a remote pc connected to internet.
All server instances are configured to allow remote connections and I have created a login too.

So in order to connect to a specfic named instatnce of sql server on <a.b.c.d> what should be the datasource in the connection string in

I guess it should be
<pc identity>/<server instance name>

< a.b.c.d>/<server1,server2,server3>

AM i right ?

Also if I need to connect to the default instance then only the ip adddress will do ?

Thanks and regards

MODS PS: I have mistakenly posted it in SQL server category so please delete it from there.
Dec 19 '08 #1
Share this Question
Share on Google+
2 Replies

P: 61
Hope this helps:
Expand|Select|Wrap|Line Numbers
  1. Data Source=.\\SQLExpress;Integrated Security=true;
  2. User Instance=true;
  3. AttachDBFilename=|DataDirectory|\InstanceDB.mdf;Initial Catalog=InstanceDB;
Follow the link for more information at
SQL Server 2005 Express Edition User Instances
Dec 19 '08 #2

P: 153
Please read my question once again.
Dec 20 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.