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
 General SQL Server Forums
 New to SQL Server Programming
 Login Failed For User <User Name>

Author  Topic 

everzcool4
Starting Member

2 Posts

Posted - 2011-10-13 : 02:10:29
Hi I am new to this forum. I am really really stucked in SQL coz I am new to sql too.

I am using SQL Server 2000. Server and client are running in Win XP SP3. Both machines have logged on using the administrator password. but when i go to "New Sql registration" in the Enterprise Manager the following error is occuring.



Guys please help me i am really need this and it is urgent.

Thank you in advance.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-10-13 : 06:34:58
You are trying to log in with the guest account but this is obviously not possible. Try to log in with the administrator account or another one that actually is allowed to log on...

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

paultech
Yak Posting Veteran

79 Posts

Posted - 2011-10-13 : 10:45:23
You can enable the guest account but that's a security risk

please see the following link :

http://support.microsoft.com/?id=831133

Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-10-14 : 02:15:50
What the he** kind of advice is that?? DO NOT enable the guest account! Unless you've been a DBA for a decade and know what you're doing and ALL the implications there is a slim (very slim!) chance that enabling the gust account could be justifyable.

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

everzcool4
Starting Member

2 Posts

Posted - 2011-10-14 : 07:15:03
Thank you very much for all of your kind replies.

@ Lumbago: I am logged as the administrator in both computers. but still i get the same problem.

if anyone can connect to computer and see what is wrong with that through teamviewer i can give the ID.

guys please help me.

Than you very much
Go to Top of Page
   

- Advertisement -