Microsoft KB Archive/831133

= SQL Server clients are authenticated as guests if Simple File Sharing is enabled =

Article ID: 831133

Article Last Modified on 5/27/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft Windows XP Home Edition

-



SYMPTOMS
You receive the following error message:

Login failed for user ‘ \guest'

You receive this error message if either of the following conditions is true:
 * You try to register a server in SQL Server Enterprise Manager.
 * You try to connect to Microsoft SQL Server 2000 by using SQL Query Analyzer from a computer that is running Microsoft Windows XP and that computer is in a workgroup.

This problem occurs even if the local user account and password match the account on the remote server.



CAUSE
This problem occurs because Simple File Sharing affects how remote users are authenticated. All remote users are authenticated as guests to SQL Server 2000 in this environment. Simple File Sharing is always enabled on computers that are running Microsoft Windows XP Home Edition. By default, Simple File Sharing is enabled on computers that are running Microsoft Windows XP Professional and that are joined to a workgroup.



MORE INFORMATION
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

304040 How to configure file sharing in Windows XP

302927 Computer Management displays user account names when logged on as Guest

Keywords: kberrmsg kbprb KB831133

-

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

© Microsoft Corporation. All rights reserved.