SQL Server Performance Forum – Threads Archive
SQL Server does not exist or access denied.
HiI am getting the following err when I connect to SQL server from my SQL client QA. But I am able to connect to the Production SQL server. I tried out all the options mentioned inhttp://support.microsoft.com/?kbid=888228 Any solutions please. Unable to connect to server dev_server Server: Msg 20, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. Thanks.
[8D]
A connection to a back-end SQL Server database may fail, and you receive the following error message:
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. This error occurs under the following conditions:
1 You are using the Microsoft ODBC Driver for SQL Server 2000 that comes with Microsoft Data Access Components (MDAC) version 2.6, 2.6 SP1, 2.6 SP2, or 2.7.
2 The TCP/IP protocol is used; in other words, the Network keyword is set to DBMSSOCN.
3 The Address keyword contains three parameters; for example, the server name or IP address, the port number, and an urgent token:"DSN=DSNName;SERVER=servername;DATABASE=pubs;Network=DBMSSOCN;Address=IP_Address,1433,urgent;"
4 The server to which you are connecting is not a local server.
-From Microsoft More info
http://support.microsoft.com/?kbid=311836
Refer to the KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306 to resolve the issue. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi Thanks a lot. I got the solution. In SQL Server Client Network Utility configuration, I just unchecked "Force Protocol Encryption" option. Now I am able to connect to my SQL server. Thank you once again. Sathish
]]>