SIGN UP

I lost sql server password, how i can reset sql sa password?

Avatar Image
Shandelzare | 09:33 Wed 15th Sep 2010 | Computers
7 Answers
I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server, Thanks in advance.

Answers

1 to 7 of 7rss feed

Best Answer

No best answer has yet been selected by Shandelzare. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Have you tried connecting as the domain administrator specifying windows authentication?
Otherwise you have to go to single user mode

http://blogs.msdn.com...-sql-server-2005.aspx
-- answer removed --
How convenient, another new user with a link to a paid for answer!

you can issue the alter login command to change the password..

ALTER LOGIN <login_name> WITH PASSWORD = <change password>

No need to use the piece of crap advertised above, it's probably riddled with spyware and viruses anyhow!
-- answer removed --
-- answer removed --
It is very easy to use some third party tool to solve the problem, it just take you less than 5 minutes to change your sql password, and even the beginner could quickly fix it.
http://www.youtube.com/watch?v=fqgQggWcp1Q

1 to 7 of 7rss feed

Do you know the answer?

I lost sql server password, how i can reset sql sa password?

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.