SQL Server clients are authenticated as guests if Simple File Sharing is enabled (831133)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
  • Microsoft Windows XP Home Edition

SYMPTOMS

You receive the following error message:
Login failed for user 'ServerName\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

Modification Type:MinorLast Reviewed:5/27/2004
Keywords:kberrmsg kbprb KB831133 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.