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$ <instancen ame>\SQL\q uery
how does that actually look? should i just use the word 'pipe'?
\\<servername>\pipe\MSSQL$
how does that actually look? should i just use the word 'pipe'?
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.
but http://support.microsoft.com/kb/888228 says i should put it differently because it is on a cluster.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
for cluster it should be:
"DRIVER=SQL Native Client;Trusted_Connection= Yes;SERVER ="np:SQLSe rverVirtua lName \Instancename"
"DRIVER=SQL Native Client;Trusted_Connection=
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$ <instancen ame>\SQL\q uery
what is the significance of the syntax recommended here:
\\<servername>\pipe\MSSQL$
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>Typically, especially with clusters, TCP/IP connectivity is what is used.
is that mandatory or preferred?
is that mandatory or preferred?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
got it! Thanks much for your helping out
ASKER
PIP007/SPL7