Please start any new threads on our new site at https://forums.sqlteam.com. 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 

pamyral_279
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.

khtan
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


KH

Go to Top of Page

SwePeso
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.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77541


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

dizzyturkey
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

yitiana
Starting Member

7 Posts

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

james8421
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 -