"Connection Could Not Be Established" Error Message When You Connect to a Windows NT 4.0-Based Computer That Is Running SQL Server 2000 or SQL Server 7.0

Article translations Article translations
Article ID: 823492 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

When you connect to a Windows NT 4.0-based computer that is running either Microsoft SQL Server 2000 or Microsoft SQL Server 7.0, you may receive an error message that is similar to one of the following:
Connection could not be established.
SQL Server does not exist.
-or-
Connection could not be established.
Access is denied.
You do not experience these symptoms if you use TCP/IP to connect to the server.

CAUSE

This problem may occur if all the following conditions are true:
  • You are running Windows NT 4.0 Service Pack 6 (SP6) or later.
  • You apply the Microsoft SQL Server update that is documented in the following article in the Microsoft Knowledge Base:
    815495 MS03-031: Cumulative Security Patch for SQL Server
  • You are not a member of the Administrators group on the client computer.

RESOLUTION

Update Information

Download Information

The following file is available for download from the Microsoft Download Center:
Windows NT 4.0 Server
Collapse this imageExpand this image
Download
Download the 823492 package now.
Windows NT 4.0 Terminal Server Edition
Collapse this imageExpand this image
Download
Download the 823492 package now.

Release Date: July 23, 2003

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to Obtain Microsoft Support Files from Online Services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

Prerequisites

This update requires Windows NT 4.0 Service Pack 6 (SP6) or Windows NT 4.0 Service Pack 6a (SP6a).

Update Replacement Information

This update does not replace any other updates.

File Information

The English version of this update has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Windows NT 4.0 Server
Date         Time   Version        Size    File name
----------------------------------------------------
25-Jun-2003  09:03  4.0.1381.7220  38,736  Npfs.sys
Windows NT 4.0 Terminal Server Edition
Date         Time   Version        Size    File name
----------------------------------------------------
25-Jun-2003  09:06  4.0.1381.33548 38,608  Npfs.sys

To Activate the Update

After you install the update on the server, you must edit the registry to activate the update. After you do so, users can connect to the server by using named pipes. To activate the update, add the
EnhancedSecurityLevelNamedPipes
registry value to the following registry key, and then set the value to 1:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager
To do so, follow these steps.Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
  1. Click Start, and then click Run.
  2. In the Open box, type regedit, and then click OK.
  3. Locate and then click the following registry entry:
    HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager
    Note Look at the key carefully. There may be a key named
    SessionManager
    (no space) rather than
    Session Manager
    (with a space). Do not use the
    SessionManager
    key; only use the
    Session Manager
    key.
  4. On the Edit menu, point to New, and then click DWORD Value.
  5. Type EnhancedSecurityLevelNamedPipes, and then press ENTER.
  6. On the Edit menu, click Modify.
  7. In the Value data box, type 1, and then click OK.
  8. Quit Registry Editor.
  9. Restart the server.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Properties

Article ID: 823492 - Last Review: October 26, 2006 - Revision: 4.4
APPLIES TO
  • Microsoft Windows NT Server 4.0 Standard Edition
  • Microsoft Windows NT Server 4.0, Terminal Server Edition, when used with:
    • Microsoft SQL Server 7.0 Standard Edition
    • Microsoft SQL Server 2000 Standard Edition
    • Microsoft SQL Server 2000 Enterprise Edition
Keywords: 
kbhotfixserver kbqfe kberrmsg kbqfe kbfix kbbug KB823492

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com