PRB: ODBC Connection Failed: SQLState: '08001' DBMSSOCN

ID: Q195566


The information in this article applies to:


SYMPTOMS

The following error message is returned from the ODBC Data Source Administrator and/or an ODBC application while attempting to make a connection to SQL Server:

Connection failed:
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][DBMSSOCN] General Network error. Check your documentation.
Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][DBMSSOCN]ConnectionOpen(connect())


CAUSE

The most common reason that this connection attempt failed is that this DSN or ODBC data source attempted to make a connection using the TCP/IP sockets Net-Library, which is Dbmssocn.dll. Because the SQL Server is not listening for incoming connections for TCP/IP sockets clients, the connection fails. From ISQL/w, the second error message stated above would be returned. The OS Error is 10061, and the function call that failed was ConnectionOpen(connect()).


WORKAROUND

By default, SQL Server will listen for incoming connections made by Named Pipes clients. Named Pipes is the default IPC mechanism for clients to connect to a SQL Server version 4.2, 6.0, and 6.5 server. The Named Pipes DLL is Dbnmpntw.dll, and it should be located in the Windows\System or Winnt\System32 directory. The most common resolution to this problem is to configure the client computer to connect using Named Pipes.

Configuring Named Pipes

If the Microsoft Data Access Components (MDAC) ODBC drivers have been installed on the computer, you can make this change in the second step of the Create New Data Source wizard.

NOTE: You can download MDAC drivers from http://www.microsoft.com/data.

To configure the client, start the Create New Data Source wizard, click the Client Configuration button, and perform the following steps, based on the version of the SQL Server ODBC driver you are using:

For SQL Server ODBC Driver version 3.50
  1. Click the Net Library tab and use the drop down list box to set the default network (Net Library) to Named Pipes.


  2. On the Advanced tab, remove any advanced entries that reference the server you are connecting to.


  3. Click Done.


For SQL Server ODBC Driver version 3.70
  1. In the Network Libraries section of the Edit Network Library Configuration dialog box, select Named Pipes.


  2. Click OK.


If you do not have the MDAC ODBC drivers installed, you can use the SQL Server Client Configuration Utility tool to set the default Net-Library to Named Pipes. You can install the client utilities from the SQL Server CD from the i386 directory.


MORE INFORMATION

This topic is also discussed in a troubleshooter available at the following location:

http://support.microsoft.com/support/tshoot/tshooterlist.asp?PR=sql

Additional query words: Win95 datasource open database connectivity netlib lib net SBS Small Business Server


Keywords          : SSrvGen SSrvNet_Lib SSrvVisB 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbprb 

Last Reviewed: April 10, 1999