Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Express Edition and Compact Edition (2005)  help! about Login failed for user '<domain>\guest'

Author  Topic  macmoy Starting Member 1 Post Posted - 2008-06-22 : 23:58:41 guys,,kindly help me please. PC name: WINDOWS-XP Laptop name: MACMOYLAPTOP both have sql server management studio express. when connecting FROM LAPTOP (MACMOYLAPTOP) using sql server management studio express(SSMSE), the error is always "Login Failed for user 'WINDOWS-XP\Guest'" then in my PC(WINDOWS-XP), i created a login account in SSMSE named WINDOWS-XP\Guest. I tried to connect again "FROM THE LAPTOP(MACMOYLAPTOP)" THE CONNECTION WAS SUCCESSFUL!! BUT!!! what will happen when another computer will try to connect?? will it be logging in again as 'WINDOWS-XP\Guest'?? AND! I dont want this setup!! why is it always logging in as Guest?? how to change it?? I hope my information is enough to be understood clearly.. I'm Hoping for you help guys!!! Thanks!!!!