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 instances of Sqlserver in my PC
"server1","serv er2" and "server3"
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 instatnce of sql server("server1 ") 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 ?
Since i am new to this can anyone be generous enough to give me some detailed explaination of the concept ?
Thanks and regards
Akshay
The name of my PC is "akshay".
And i have got 3 instances of Sqlserver in my PC
"server1","serv er2" and "server3"
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 instatnce of sql server("server1 ") 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 ?
Since i am new to this can anyone be generous enough to give me some detailed explaination of the concept ?
Thanks and regards
Akshay
Comment