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:
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