Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
JSI Tip 7631. SQL Server Windows XP clients are authenticated as guests if Simple File Sharing is enabled?
Jerold Schulman
January 5, 2004
1 Min Read
When you attempt to register a server in SQL Server Enterprise Manager, or you attempt to connect to SQL Server 2000 by using SQL Query Analyser, AND your computer is NOT in a domain, you receive:
Login failed for user
This problem occurs because all remote users are authenticated as quests to SQL Server 2000 when Simple File Sharing is enabled.
NOTE: See How do I disable Simple File Sharing on Windows XP Professional?
About the Author(s)
You May Also Like
.jpg?width=700&auto=webp&quality=80&disable=upscale)
.jpg?width=700&auto=webp&quality=80&disable=upscale)