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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Shandelzare
    Banned
    New Member
    • Sep 2010
    • 1

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

    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.
  • Rylai
    New Member
    • Sep 2010
    • 1

    #2
    reset sql sa password

    Hi, you can try to use command prompt to reset your lost password. I have used it to reset sql sa password successfully on sql server 2000/2005.
    First, open a command prompt (Start -> Run -> cmd)
    Then, type the follow commands, and press Enter after each line:
    Osql –S yourservername –E
    1> EXEC sp_password NULL, 'yourpassword', 'sa'
    2> GO
    It could help you.
    Last edited by Niheel; Sep 5 '11, 09:00 AM.

    Comment

    Working...