I made the most ridiculous thing. I accidentally disabled both remote logins and database accesses for the Administrator accounts (including the one with Windows Authentication (Administrator account) and sa account on the production server! Please tell me a way that there is a way to access the server with administrator privileges! :(

Is it possible from an installation or some kind of command line etc?

Again, Administrator account IS disabled for SQL Server (but I have remote connection to server, the account itself is working...)

The Administrator account of the SERVER is AAAAA\Administrator, and the instance is SOMETHING\SOME_INSTANCE.

When I am trying to log in from the remote desktop (on the server itself) with the AAAA\Administrator account, it says its disabled:

enter image description here

  • Have you tried logging in using DAC account? Nov 2 '16 at 15:03

You need to start SQL Server in single-user mode.

The documentation Connect to SQL Server When System Administrators Are Locked Out says:

Start the instance of SQL Server in single-user mode by using either the -m or -f options. Any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.

See the page linked above for further considerations and step-by-step instructions.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.