I am not able to Connect to SQL Server when system administrators are locked out

Question

My administrator account is locked. I followed the step provided here https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out?redirectedfrom=MSDN&view=sql-server-ver15 still i am getting that your account is locked. I even tried with "SQL Server Configuration Manager" and faced same issue. Could you help me on this?

Answer 1

So this is a slightly different situation from the one described in the article. In that article, all sysadmin accounts have been deleted from Windows, and the sa login is not available.

In this case, your account is available, but it has been disabled.

The remedy would be to create a second account in Windows with administrator rights (if you don't have one already) and then run SQLCMD as this account. (Which you can do with help of the RUNAS command.)

Answer 2

Hi @Lokesh Kumar Pattajoshi.

Take a look at this blog to see if it is helpful.

How to connect to SQL Server when you're locked out

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.