Microsoft KB Archive/125399

= "Connection Failed" Error Connecting to SQL Server =

Article ID: 125399

Article Last Modified on 6/11/2007

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 5.0 for Macintosh
 * Microsoft Query 2000

-



This article was previously published under Q125399



SYMPTOMS
When you connect to an SQL Server data source, such as Microsoft SQL Server or Sybase SQL Server, you may receive the following error message:

Connection Failed:

SQLState: '08001'

SQL Server Error: -1

[Microsoft][ODBC SQL Server Driver]Unable to connect to data



CAUSE
This error message usually indicates that the client workstation cannot find the SQL Server on the network. Possible causes for this problem include the following:

  If you are using Microsoft Query for Windows or Windows NT   --

- TCP/IP Sockets support has not been enabled on the SQL Server.

- The client workstation has not been set up to run TCP/IP properly.

- The SQL Server data source has not been setup with the proper TCP/IP address for the server.

If you are using Microsoft Query for the Macintosh -

- You may receive the error message stated above if the MacTCP Control Panel device has not been installed.



Method 1: Enable TCP/IP on the SQL Server (Windows NT)
To do this, follow these steps:


 * 1) Run the SQL Server Setup program from the SQL Server.
 * 2) In Options dialog box, click the Change Network Support option, and then click Continue.
 * 3) Make sure the TCP/IP Sockets option is selected, and then click OK.
 * 4) The next two dialog boxes display the Port Number and Network Address.

You should not need to change these, but you should verify that they are correct.
 * 1) Return to Windows NT.

Method 2: Configure the Client Workstation for TCP/IP Connectivity
Microsoft Query for the Macintosh:

In Microsoft Query for the Macintosh, you may receive the error message described in the "Symptoms" section if the MacTCP Control Panel device has not been installed. MacTCP is distributed with Apple Macintosh System 7.5. To add the MacTCP icon to the Control Panels folder, run the Setup program for System 7.5.

Additional query words: ODBC TCP IP connectivity MSQuery

Keywords: kbenv kbnetwork KB125399

-

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

© Microsoft Corporation. All rights reserved.