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

This article mainly introduces how to solve the problem that the sqlserver account is banned. It has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let the editor take you to know it.

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 this article carefully. I hope the article "how to solve the problem of sqlserver account being banned" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and follow the industry information channel. More related knowledge is waiting for you to learn!

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.