Hi,

I can not enter the SQL Server on my laptop (Win XP) from my PC (Win 2000) under my integrated Win login. It lets me in as a Guest only.
What to do?
(In the opposite direction it goes OK.)

Thanks!
Mladen

Check which mode you have used for authentication on both machines. Do you have client on one and server on the other.

I have used the same mode on both machines and that is - the login for Windows serves automatically as login for SQL Server.

I believe this is because you are not within the same domain. Have you actualy setup a domain for your network?



Sal

This has nothing to do with one being client and one being server.



Sal

Thanks for helping me.
Yes, I have setup a domain on both machines, if we think on same thing. I think on choosing domain option during install process of the SQL Server. My network is in fact these two machines. The domains got their names from the machines' names.
Thanks once more. Best regards,
Mladen
P.S. I will be absent till July 2.

You may have indeed two sepparate domains. I am not as good with networking, but I have has this issue only when the SQL Server was not in the domain or in a Netware environment.

When you installed the first windows OS, did you create a domain, ?

when you installed the second OS, did you create a new domain or did you join an existing domain?

You mention creating a domain on both machines, this two domains may not nessesarily be the same domain.

try this site and do a search on this:

www.sqlmag.com

You should be able to find your answer there. It may just be a simple network configuration of making the client a part ot the domain of the server.

When you come back, let us know how you are doing with your issue.



Sal

The problem WAS in ForceGuest=1.
Thanks for help!

Mladen