Login failed for user "myDomain\Guest"
-
Hello I'm trying to connect to SQL Server2000 that in another computer in local area network. but it says login failed for user "Guest" - I added my windows account (MyDomain\MyWindowsUserName) to SQL Server. - I use windows only authentication. - both computers are Windows XP Pro-service pack 2 - When I add Guest windows user to SQL server, it works fine.. But I don't want to use Guest account. - both computers are in same WorkGroup - I added user name to server computer with exactly same user name and password. any help... thanks
-
Hello I'm trying to connect to SQL Server2000 that in another computer in local area network. but it says login failed for user "Guest" - I added my windows account (MyDomain\MyWindowsUserName) to SQL Server. - I use windows only authentication. - both computers are Windows XP Pro-service pack 2 - When I add Guest windows user to SQL server, it works fine.. But I don't want to use Guest account. - both computers are in same WorkGroup - I added user name to server computer with exactly same user name and password. any help... thanks
denizmercan wrote:
I added user name to server computer with exactly same user name and password.
Have u added username in Sqlserver Database Users? "Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshers http://himabinduvejella.blogspot.com
-
denizmercan wrote:
I added user name to server computer with exactly same user name and password.
Have u added username in Sqlserver Database Users? "Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshers http://himabinduvejella.blogspot.com
Yes I added.. and I gave full permission to that user.
-
Yes I added.. and I gave full permission to that user.
I am asking whether u have added user name in enterprize manger users ie database users Got me "Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshers http://himabinduvejella.blogspot.com
-
I am asking whether u have added user name in enterprize manger users ie database users Got me "Aim to go where U have never been B4 and Strive to achieve it" http://groups.yahoo.com/subscribe/dotnetforfreshers http://himabinduvejella.blogspot.com
Yes I did what you say...