"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

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: You do not experience these symptoms if you use TCP/IP to connect to the server.

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  (http://support.microsoft.com/kb/815495/ ) MS03-031: Cumulative Security Patch for SQL Server
• You are not a member of the Administrators group on the client computer.

Update Information

Download Information

The following file is available for download from the Microsoft Download Center:

Windows NT 4.0 Server

Download the 823492 package now. (http://microsoft.com/downloads/details.aspx?FamilyId=E238B8A1-4146-400A-A6F6-68E0D3B44163&displaylang=en)

Windows NT 4.0 Terminal Server Edition

Download the 823492 package now. (http://microsoft.com/downloads/details.aspx?FamilyId=BC72BE54-081D-43AE-B9C9-D08496C03BA3&displaylang=en)

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: 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

Windows NT 4.0 Terminal Server Edition

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: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:

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.

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