INF: Guest Access to SQL Server on Windows NT Advanced Server

 Last reviewed: April 3, 1997
Article ID: Q104623

The information in this article applies to: 

  - Microsoft SQL Server Programmer's Toolkit, version 4.2

When attempting to connect to a SQL Server running on a Windows NT Advanced Server and the user does not have an account on the Advanced Server, the domain in which the server is a part or a domain trusted by the server, the client may be unable to connect.

Errors from the client application will be:

DB-Library error: 

   Unable to connect: SQL Server is unavailable or does not exist
Net-Library: 

   Error 5 ConnectionOpen (DosOpen()).
The READPIPE utility will fail to connect to MAKEPIPE running on the Windows NT server with: 

   READPIPE status = 5 (accessdenied).
These errors may be due to an inactive Guest account on the Windows NT Advanced Server. This account defaults to inactive when Windows NT Advanced Server is installed.

To enable the guest account:

  1. From the Administrative Tools group, select User Manager.

  2. Double-click on the entry for Guest.

  3. Clear the Account Disabled check box in the User Properties dialog box and press OK.

Clients without global or local accounts will now be able to successfully connect to SQL Server on the Windows NTAS server.

Additional query words: 4.20 SAF ISQL SQL Admin Object Manager
Keywords : kberrmsg kbother
Version : 4.2
Platform : WINDOWS
Issue type : kbtshoot

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: April 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.