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

You receive the following error message: 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.

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.

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