Shulou(Shulou.com)06/01 Report--

What if the sqlserver account is disabled? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Undefined

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

(1) under Sqlserver's "configuration tools" SQL Server configuration Manager, select "Sql Serve Services" to expand and stop all sql services.

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

Net stop sqlserver instance name (you can select SQL Server (...) under the Sql Serve service) Right-click to find the net start sqlserver instance name / m (you can select SQL Server (...) under the Sql Serve service.) Right-click to find it in the properties)

(3) then execute the sqlcmd command (not clear how to use it, 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, you can log in using your kk account, and then enable your desired account

Thank you for reading! After reading the above, do you have a general idea of what to do when the sqlserver account is disabled? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.