Help! Passwords Expired

Question

Post reply

Help! Passwords Expired

Dhruva Hein

SSC Rookie

Points: 44
More actions
January 2, 2009 at 9:17 pm

#127770

Unfortunately, the password for my two logins (SQL Server Authentication) have expired and I cannot locate my sa password.
When I tried to log in, I just got the message box asking for the password. I cannot figure out how to solve this problem and access the server.
Does anyone have an idea about what I can do?
Thanks very much.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

This post should help you.

http://www.sqlservercentral.com/Forums/Topic253723-5-1.aspx

Pradeep Singh

ps. One Orange Chip Points: 29422 More actions · Answer 2

Raul Garcia's blog contains an excellant article on this.

http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

Pradeep Singh

ps. One Orange Chip Points: 29422 More actions · Answer 3

opps!! i overlooked the forum (its sql 2000) and the links i mentioend contains reference to sql 2005...

THis site contains a workaround on this for both sqlk 2000 and sql 2005.

http://www.simple-talk.com/sql/t-sql-programming/temporarily-changing-an-unknown-password-of-the-sa-account-/

Pradeep Singh

Dhruva Hein SSC Rookie Points: 44 More actions · Answer 4

You guys are great! I saw one of your posts went up at 4:45 local time!

In the end, I logged onto Windows as Administrator and -- as distinct from its behavior with my regular Windows ID -- the Management Studio gave me the opportunity to change all my passwords.

Which I did -- and I wrote them ALL down.

Thanks to everyone who responded to my plea.

Dhruva

ps. One Orange Chip Points: 29422 More actions · Answer 5

Hmmm.. Seems builtin\administrators have sysadmin role on your server.

Pradeep Singh