|
|
|
|
|
I've forgotten the sa password
for SQL Server - what can I do? The easiest way around this is to logon to the actual SQL Server NT machine itself as administrator. Then connect to SQL Server using any of the tools and specify "." as the server name and ask for a trusted connection. As long as the admins group hasn't been explicitly removed from having sa rights then you should connect ok and be able to reset the password. If you're in mixed-mode and you know the NT userid of someone with sa rights, then get their password reset and logon/connect as them. Otherwise you can try and find a dba's machine who already has the server registered to SQL EM with sa and use that copy of SQL EM to connect. If all these fail then you'll have to rebuild master and disk reinit (6.x) or re-attach (7.x) all the user databases. |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.