Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 831133 - Last Review: May 27, 2004 - Revision: 1.4
SQL Server clients are authenticated as guests if Simple File Sharing is enabled
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.
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:
304040Â
(http://kbalertz.com/Feedback.aspx?kbNumber=304040/
)
How to configure file sharing in Windows XP
302927Â
(http://kbalertz.com/Feedback.aspx?kbNumber=302927/
)
Computer Management displays user account names when logged on as Guest
APPLIES TO
- Microsoft SQL Server 2000 Standard Edition
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft Windows XP Home Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
Dennis Breen
- dbreen NOSPAM-AT-NOSPAM infinitidesigns.com
|
Report As Irrelevant
|
| Written:
10/21/2005 8:57 AM |
|
|
|
manoj
- manojbandgar NOSPAM-AT-NOSPAM rediffmail.com
|
Report As Irrelevant
|
| Written:
10/3/2006 1:27 AM |
|
|