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

Today, I will talk to you about the sqlserver account is disabled processing methods, many people may not know, in order to let everyone know more, Xiaobian summarized the following content for everyone, I hope you can harvest according to this article.

What if all sqlsrver accounts are disabled accidentally? Do you need to reload? No need. Watch carefully how Little White solves this puzzle step by step.

First you need to add a new account to Windows account settings. And add it to the administrator group, and then follow the following steps (note/m is to switch to single-user login mode, after modification, it is recommended to switch to multi-user mode):

(1) Go to SQL Server under "Configuration Tools" SQL Server Configuration Manager, select "SQL Server Service" to expand, and stop all SQL services.

(2) Run cmd.exe as an administrator and execute the following command:

net stop sqlserver instance name (SQL Server(...) can be selected under Sql Serve Right-click properties to find) net start sqlserver instance name/m (you can select SQL Server(...) under Sql Serve service Right click properties found)

(3) Next execute sqlcmd command (do not know how to use, you can use Baidu sqlcmd), enter in the following order, and enter to execute.

create login kk with password='kk#12345'; go sp_addsrvrolemember 'kk', 'sysadmin' go

(4) Repeat (2) and remove/m. After success, and can use kk account login, and then enable their desired account

After reading the above, do you have any further understanding of how to handle sqlserver account being disabled? If you still want to know more knowledge or related content, please pay attention to the industry information channel, thank you for your support.

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.