Connection String

[akshaycjoshi]

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","serv er2" 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 ado.net?

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

< a.b.c.d>/<server1,server 2,server3>

AM i right ?

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


Thanks and regards
Akshay

MODS PS: I have mistakenly posted it in SQL server category so please delete it from there.

[Ramk]

Hope this helps:

Data Source=.\\SQLExpress;Integrated Security=true;
User Instance=true;
AttachDBFilename=|DataDirectory|\InstanceDB.mdf;Initial Catalog=InstanceDB;

Follow the link for more information at
SQL Server 2005 Express Edition User Instances

[akshaycjoshi]

Please read my question once again.