Qida, Manager SQL Server set password PJ Method

Generally, the password of the sa or administrator user is forgotten in SQL Server Password Authentication mode.
First, open the Registry Editor (enter regedit in "Run") and find [HKEY_LOCAL_MACHINE \ SOFTWARE \ MICROSOFT \ MSSQLSERVER]. This item contains a key value LoginMode, now the value is 1, change the value to 2, and restart the computer;
Open Enterprise Manager, right-click "Edit SQL Server Registration attributes", select "use Windows Authentication", and click OK to connect to the database Server. In this case, the "Security ~" Log on to the SAS console to change the password of the sa or administrator;
Open the Registry Editor again (enter regedit in "run"), find [HKEY_LOCAL_MACHINE \ SOFTWARE \ MICROSOFT \ MSSQLSERVER], change the value of LoginMode to 2, and restart the computer;
Open Enterprise Manager, right-click "Edit SQL Server Registration attributes", select "use SQL Server Authentication", and enter the corresponding administrator user name and password to connect to the database Server.

Administrator Password PJ:
Many financial software users in guanjiapo have forgotten the administrator password. What should I do?
Is it a direct software reinstallation or a new set of books? It doesn't matter, but there is still a way to get it back. below
I will introduce how to retrieve the password:
1. Open the SQL Enterprise Manager, open it in the root directory of the console, and find "Database"-the "table" under your Manager database"
2. Find "employee" on the right side, right-click "Open Table", and "return all rows". Remember the "typeID" corresponding to the user name"
3. Enable "loginuser", and the password corresponding to etypeID is the password.
All of the above are effective in guanjiapo Clothing SHOES 8.169, brilliant 2008 +, and clothing 2008 + trials

So the password that protects your SQL sa permissions is actually protected.
---- Like speed up, the passwords of speed up to 3000 are in the operator table, and both finance and 5000 are in the m_operator table. All are plain text.
You can check all the software that uses SQL databases!