PRB: Unable to Connect to Stand-Alone SQL Server

Last reviewed: January 21, 1998
Article ID: Q171225
The information in this article applies to:
  • Microsoft SQL Server, versions 4.2x, 6.0, and 6.5

SYMPTOMS

Attempting to connect to SQL Server on a stand-alone computer or a laptop computer with no network connections may fail with the following error message:

   Unable to connect: SQL Server is unavailable or does not exist.
   Specified SQL server not found.

This error may occur during installation, or during subsequent attempts to connect to the server.

CAUSE

By default, client connections to SQL Server are made over a network protocol. Without a simulated network connection, the connection to SQL Server cannot be made unless a local named pipes connection is forced.

WORKAROUND

To simulate network connectivity, install the MS Loopback Adapter according to the following steps for the version of Windows NT Server you are using:

Windows NT Server 4.0:

  1. In Control Panel Network, click the Adapters tab and then click Add.

  2. From the list, select the MS Loopback Adapter.

Windows NT Server 3.x:

  1. In Control Panel Network, click Add Adapter.

  2. From the Network Adapter Card menu, select MS Loopback Adapter.

The Windows NT installation CD is required. If you are using the IPX/SPX protocol, a frame type of 802.3 is the default, and should be accepted. For TCP/IP configurations, specify an IP address of 100.100.100.001 and a subnet mask of 255.255.255.000. You will need to restart Windows NT Server for this change to become effective.

If you are unable to install the MS Loopack Adapter, shut down the workstation service (through Control Panel Services) to force a local named pipes connection to be made during installation. Be aware that this approach extends the installation time considerably. After the server is installed, you can restart the workstation services. For subsequent connections, you can force a local named pipes connection to the server by not specifying the server name at connection time. You may also specify ".", or "(local)" as the server name in ISQL/w and in SQL Enterprise Manager when registering the server. Alternatively, you can add an advanced entry in the client configuration utility, specifying ".", or "(local)" as the connection string for the server name.

For 16-bit applications, the MS Loopback Adapter is required. For more information, see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q130745
   TITLE     : Connecting to Standalone SQL Server Using 16-bit Apps.

If you have removed all network support and stopped the workstation service, but still continue to get the Unable to connect error, do the following:

  1. From a command prompt, type the following:

    cd \sql\binn setup /t RegistryRebuild = On

    NOTE: For SQL Server version 6.0, you can use either = On or = True for the Setup command line.

    NOTE: For SQL Server version 6.5, the default directory is \Mssql\Binn.

    NOTE: Be sure to type the Setup command exactly as indicated, including capitalization. There must be a space on both sides of the equal sign.

  2. Build your master. When the retry dialog appears, task out and setup an advanced client config as the server name, named pipes, ".". Then press the retry button in SQL Server setup.

  3. Once you have a valid master built, run the upgrade to ensure all scripts are active. This may again encounter the login error. Reset the client configuration advanced entry.


Additional query words: FAQ notebook stand-alone fails
Keywords : kbbug4.2x kbbug6.00 kbbug6.50 SSrvInst SSrvWork kbnetwork kbsetup
Version : 4.2x 6.0 6.5
Platform : WINDOWS
Issue type : kbprb
Solution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 21, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.