I am not aware of any way to recover a lost SA password. However, if you have any other account with administrator privileges (either SQL Server accounts or Windows if you run in mixed mode) you can use that account to reset the SA password.

Kevin

-----Original Message-----
From: Aaron [mailto:mssqldba-ezmlmshield-x50060513.[Email address protected]
Sent: Thursday, July 29, 2004 6:52 AM
To: LazyDBA Discussion
Subject: Retrieve Lost SA password

Is it possible to retrieve a lost SA password on a SQL 2000 Server?


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 7/22/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 7/22/2004


MS Sql Server LazyDBA home page