ray

I am trying to connect to SQL Server on a second
computer. I am logged into both computers with
Administrative Privileges. The login names are the same on
both computers using Windows XP. When I try to connect to
SQL Server I get the message "Login Failed for
DomainName\Guest." The DomainName is the name of the
computer I have SQL Server installed.

Basically, I'm trying to log in using Windows
Authentication. The network is finding the Server O.K
because it lists it when I Register the Server. It just
won't let me log in.

sue hoegemeier

Having the same logins, passwords doesn't matter when using
XP. If this is a workgroup setting, networking access for XP
uses the guest account.
Have you tried adding the guest account as a SQL login?

-Sue