sql server connect: Connect to SQL Server from Client Using Windows Authentication -- sql server connect

Connect to SQL Server from Client Using Windows Authentication

Mike Thomas
2/18/2005 9:38:43 AM

sql server connect:

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

Re: Connect to SQL Server from Client Using Windows Authentication

Sue Hoegemeier
2/21/2005 7:20:55 AM

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
http://support.microsoft.com/?id=831133

-Sue

On Fri, 18 Feb 2005 09:38:43 -0500, "Mike Thomas"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.