Microsoft KB Archive/888228

= You receive a &quot;SQL Server does not exist or access denied&quot; error message when you try to connect to a SQL Server named instance in a cluster by using TCP/IP sockets =

Article ID: 888228

Article Last Modified on 4/6/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Standard Edition

-



Bug #: 471480 (SQL Server 8.0)



SYMPTOMS
When you try to connect to a clustered Microsoft SQL Server 2005 or Microsoft SQL Server 2000 named instance by using the &quot;servername\instancename&quot; syntax, you receive the following error message:

[DBNETLIB][ConnectionOpen (Connect).]SQL Server does not exist or access denied.

You may receive this error message when the following conditions are true:
 * SQL Server 2005 or SQL Server 2000 is installed on a cluster.
 * You are connecting to a SQL Server named instance by using TCP/IP sockets.
 * IPSec policy is enabled on the client domain.
 * IPSec policy is not enabled on the server domain.



CAUSE
This problem occurs during the discovery phase of the connection. The IPSec policy on the client drops packets from the server when the source IP changes.



WORKAROUND
To work around this problem, you have to hardcode the TCP port or the Named Pipe of the SQL Server named instance. To do this, use a connection string that is similar to one of the following: [oledb] Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=clientID;Data Source=tcp:TcpIpAddress,port
 * Hardcoded TCP OLE DB initstring

[oledb] Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=clientID;Data Source=np:\\ServerName\pipe\MSSQL$InstanceName\sql\query
 * Hardcoded Named Pipes OLE DB initstring



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For additional information about how to troubleshoot connectivity issues in SQL Server 2000, click the following article number to view the article in the Microsoft Knowledge Base:

827422 How to troubleshoot connectivity issues in SQL Server 2000

Additional query words: SQL2000 UDP

Keywords: kberrmsg kbtshoot kbprb kbsql2005cluster KB888228

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.