A connection to a back-end SQL Server database may fail with the following error:[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:
- 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.
- The TCP/IP protocol is used; in other words, the Network keyword is set to DBMSSOCN.
- The Address keyword contains three parameters; for example, the server name or IP address, the port number, and an urgent token:
The server to which you are connecting is not a local server.