Link to home
Start Free TrialLog in
Avatar of 25112
25112

asked on

example for Connecting by server name to a named instance

http://msdn.microsoft.com/en-us/library/ms189307.aspx has this syntax as example:
\\<servername>\pipe\MSSQL$<instancename>\SQL\query

how does that actually look? should i just use the word 'pipe'?

Avatar of 25112
25112

ASKER

the server i am trying to connect through linked server is on a cluster and is called
PIP007/SPL7
Avatar of 25112

ASKER

right now, i am putting the servername as PIP007/SPL7
but http://support.microsoft.com/kb/888228 says i should put it differently because it is on a cluster.
SOLUTION
Avatar of Metehan Ozcullu
Metehan Ozcullu
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
for cluster it should be:
"DRIVER=SQL Native Client;Trusted_Connection=Yes;SERVER="np:SQLServerVirtualName \Instancename"
Avatar of 25112

ASKER

ServerName\InstanceName is PIP007\SPL7; is that not the same as :SQLServerVirtualName \Instancename?

what is the significance of the syntax recommended here:
\\<servername>\pipe\MSSQL$<instancename>\SQL\query
SOLUTION
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 25112

ASKER

>>Typically, especially with clusters, TCP/IP connectivity is what is used.
is that mandatory or preferred?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 25112

ASKER

got it! Thanks much for your helping out