You don't mention the specific operating systems involved.
With XP home, authentication is done using the guest account
as simple file sharing is always enabled on XP Home. You
could hit the issue with XP Pro if simple file sharing is
used. It's optional but is the default with XP Pro. How you
address the issue depends somewhat on what specific
operating systems are involved. Refer to the following for
more info:
SQL Server clients are authenticated as guests if Simple
File Sharing is enabled
<a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/?id=831133" target="_blank">http://support.microsoft.com/?id=831133</a>
-Sue
On Fri, 18 Feb 2005 09:38:43 -0500, "Mike Thomas"
wrote:
>On a newly installed workgroup computer, the client, I've been able to
>establish connections to the SQL Server on a different computer using SQL
>authentication via ODBC and Query Analyzer.
>
>Now I am trying to figure out how to connect with WIndows authentication.
>
>On the client computer (PCMAX04), when I try to login to SQL Server via QA,
>the error reads "Login failed for user DELLJAN2005\Guest" even though I am
>logged in to the client computer as MST.
>
>DELLJAN2005 is the name of the SQL Server and the computer on which it is
>installed.
>
>In SQL Server, there is a login named "DELLJAN2005\MST".
>
>How can it arrange it so that when I log on from the client computer using
>Windows authentication, SQL Server interprets the login as being for "MST"?
>
>Many thanks,
>Mike Thomas
>
>
>
>
>
>
>
FAQ
Search
Profile
Private Messages
Log in
