locked
Recovering system administrator password in SQL Server Express RRS feed

  • Question

  • Can anyone tell me if it is possible to recover the system administrator password?....or do I have to uninstall and start over?

    Thanks.
    Tuesday, December 15, 2009 6:28 PM

Answers

  • hi,
    you can not, but you can modify it accordingly to your needs.. you usually had the chance, at install time, to add your "Administrators" local WinNT group to the administrators SQL Server role, so you just need to log in SQL Server using the tool of your choice under the credential of a local administrator using the integrated security connection mode.. then you just need to alter the "sa" login with an appropriate password as required...
    regards
    http://www.asql.biz - DbaMgr2k - DbaMgr and further SQL Tools
    Tuesday, December 15, 2009 11:48 PM