Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 forget password sa in sql server 2005

Author  Topic 

Posting Yak Master

143 Posts

Posted - 2007-01-29 : 03:36:02
I have forgotten password of user sa in sql server 2005.
But if authentication is window . I still login, and do work normal.
So how to solve problem ,if authentication is sql server.
Thank you very much.

In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-29 : 03:38:45
use the administrator a/c in the Server machine to login and reset sa password


Go to Top of Page

Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-29 : 03:46:11
Or try this, if you previously has added your database server to the SSMS or EM console with SA account.

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Starting Member

2 Posts

Posted - 2010-02-03 : 02:17:50
MS SQL Server Password Unlocker helps to reset sa password saved in master.mdf of SQL server 2005! I had forgotten the sa password last week, and I fortunately found the MS SQL Server Password Unlocker at a password recovery blog. There are many password recovery solutions including SQL password recovery.

url removed
Go to Top of Page

Starting Member

7 Posts

Posted - 2010-08-17 : 22:06:08
Change SQL Server Password by Windows Authentication
Go to Top of Page

Starting Member

1 Post

Posted - 2011-05-10 : 10:34:16
I usually use SQL Server Password Changer 1.3 program.
Go to Top of Page

- Advertisement -