Donate SIGN UP
Home > Technology > Computers > I lost sql server password, how i can reset sql sa password?

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

Avatar Image
Shandelzare | 08: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.
prev Graphics Card Update
  
next Airport Express Problems
Gravatar

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.
Avatar Image jake-the-peg
Have you tried connecting as the domain administrator specifying windows authentication?
08:44 Wed 15th Sep 2010
Avatar Image jake-the-peg
Otherwise you have to go to single user mode

http://blogs.msdn.com...-sql-server-2005.aspx
08:46 Wed 15th Sep 2010
-- answer removed --
Avatar Image ChuckFickens
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!
09:45 Wed 15th Sep 2010
-- answer removed --
-- answer removed --
Avatar Image dujiaojing0
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
04:02 Thu 09th Jun 2011

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.