Microsoft KB Archive/823492

= &quot;Connection Could Not Be Established&quot; 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 ID: 823492

Article Last Modified on 10/26/2006

-

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 </li></ul>

-

<div class="notice_section">

<div class="notice_section">

Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

<div class="symptoms_section">

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.

<div class="cause_section">

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.</li> 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

</li> You are not a member of the Administrators group on the client computer.</li></ul>

<div class="resolution_section">

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

Windows NT 4.0 Server
Download the 823492 package now.

Windows NT 4.0 Terminal Server Edition
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
<pre class="fixed_text">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
<pre class="fixed_text">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  registry value to the following registry key, and then set the value to 1:

To do so, follow these steps.WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk. <ol> Click Start, and then click Run.</li> In the Open box, type regedit, and then click OK.</li> Locate and then click the following registry entry:

Note Look at the key carefully. There may be a key named  (no space) rather than   (with a space). Do not use the  key; only use the   key.</li> On the Edit menu, point to New, and then click DWORD Value.</li> Type EnhancedSecurityLevelNamedPipes, and then press ENTER.</li> On the Edit menu, click Modify.</li> In the Value data box, type 1, and then click OK.</li> Quit Registry Editor.</li> Restart the server.</li></ol>

<div class="status_section">

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

Keywords: kbhotfixserver kbqfe kberrmsg kbqfe kbfix kbbug KB823492

-

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

© Microsoft Corporation. All rights reserved.