sa password lost - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

sa password lost

Author

Topic

chaithanya
Starting Member

17 Posts

Posted - 2004-10-13 : 04:39:11

hi all,

i am not allowed to access SQL Server with the normal sa and the password. it's throwing the message 'SQL login failed'.
what might be the reason. and if i forgot the sa password how to access SQL server now?

Chaithanya J

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-10-13 : 04:40:54

are you mixed mode authentication?
if yes, then just use windows authentication from the server and you'll get in, pray that builtin administrators were not removed yet.

--------------------
keeping it simple...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-13 : 13:19:24

If you are not allowed to access SQL Server using sa, then why are you trying to figure out what the sa password is?

Tara

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-10-13 : 22:45:16

You're probably getting SQL Login failed because your SQL Login is supposed to fail. This security stuff is kewl.

I think Tara might be onto something here.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

pyeoh
Starting Member

18 Posts

Posted - 2004-10-13 : 23:02:59

>> You're probably getting SQL Login failed because your SQL Login is supposed to fail. This security stuff is kewl. I think Tara might be onto something here.

You guys (and girls) are hilarious.

Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backups? Use MiniSQLBackup Lite, free!

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-10-13 : 23:06:30

cmon guys, give her/him a break, it's just probably how it was phrased, else i don't think the question will be posted here.

so what's the deal chaithanya?

--------------------
keeping it simple...

chaithanya
Starting Member

17 Posts

Posted - 2004-10-14 : 00:32:38

thnx jen, u helped me out nd it's so simple
Guys, <<i am not allowed to access SQL Server with the normal sa and the password. >>. it's a bad phrasing..

Chaithanya J

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-10-14 : 00:43:09

no problem. don't forget to change your sa password, write it down, keep in a safe place. and create a login for yourself (i'm assuming you're the DBA), standard and windows.

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources