Shulou(Shulou.com)05/31 Report--

This article will explain in detail the solution of forgetting the password of the MSSQL Server administrator. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Generally, it means that in SQL Server password authentication mode, the password of the sa or administrator user is forgotten.

First, open the registry editor (enter regedit in "run") and find [HKEY_LOCAL_MACHINE\ SOFTWARE\ MICROSOFT\ MSSQLSERVER\ MSSQLSERVER]. This key has a key value of LoginMode, which is now 1, change the value to 2, and restart the computer.

Open the enterprise manager, right-click "Edit SQL Server registration properties", select "use Windows authentication", click OK, you can connect to the server. At this point, you can change the password of the sa or administrator user through "Security ~" login.

Open the registry editor again (enter regedit in "run"), find [HKEY_LOCAL_MACHINE\ SOFTWARE\ MICROSOFT\ MSSQLSERVER\ MSSQLSERVER], change the LoginMode value to 2, and restart the computer.

Open the enterprise manager, right-click "Edit SQL Server registration properties", select "use SQL Server authentication", enter the corresponding administrator user name and password, you can connect to the database server.

This is the end of this article on "the solution to the MSSQL Server administrator's forgotten password". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.