lost password for sa

[joeythelips]

Hi,

is there anyway of resetting/retrieving an sa password?

i have recently taken over the administartion of a db but no-one in the company has the password!!

 

[btturner]

IF" you have another SQL sysadmin password:
- login under this ID
- In Ent. Mgr, expand Security
- Under Logins, select "sa" id's properties
- you can change the password there

"IF" you don't have another SQL sysadmin password
- you may need to DETACH your appl DB's
- script off your JOBS
- script your Logins (see

http://support.microsoft.com/default.aspx?kbid=246133

)
- save off your DTS pkg's as SSF's
- uninstall & reinstall SQL server which will allow you to recreate the "sa" password (mixed mode authentication)

 

[SonOfEmidec1100]

Three steps to salvation

1. Log on to the macine running SQL Server with local administrator rights.
2. Connect to SQL Server using Windows NT authentication.
3. Open Query Analyzer, run this system stored procdeure to reset the password
[blue]sp_password @new = 'newpassword', @loginame = 'sa'[/blue]