SQL2005 sa Password forgotten

Category: MS-SQL Server -> Foundation Classes Author: lengjie1987 Date: 2008-05-11 09:13:31
 
lengjie1987
2008-05-11 09:13:31
SQL2005 sa password is forgotten, with windows identity can not login, this should be how to solve ah
jjhhug
2008-05-11 09:30:52
  1  "  windows  "  sql server  ,
:

1. " "-" ", regedit,
2. , :
[hkey_local_machine\software\microsoft\mssqlserver\mssqlserver]
3. "loginmode",
4. 1 2, " "
5.
6. sql server .

, sa sql server ,
windows sql server.
 sql server  :
  builtin\administrators
  < >\administrator  .
, :

1. , ,
2. " ", " ", " "
3. " " ,  builtin\administrators
4. " " , "system administrators"  
5. " "
6.  < >\administrator  .

:

:
hkey_local_machine\software\microsoft\mssqlserver\mssqlserver\loginmode
sql server .
1. "windows  "
2. (windows   sql server  ).
[email protected][email protected]
HOW TO:  MSDE 
www5055
2008-05-11 09:44:57

WINDOWS Login disabled? like no way, reinstall it
wybjj
2008-05-11 09:58:55
me this is 2005, not 2000
l76252373
2008-05-11 10:18:30


original 2000 approach:

If LZ really did not move, the service is down, and then copy the data file.

delete the original SQL Server, and then re-install, then attach the file.

operational risk, Please handle with caution.