See the article Connect to SQL Server when system administrators are locked out.
[SQL Server Management Studio] Windows Account Login Disabled
Emanuel Delgado Neves
0
Reputation points
Hi, everyone.
In a business environment i work with a software (Bizagi Studio), which uses SQL Server Management Studio (SSMS) for the database (DB).
From time to time, I have to correct some data directly in the DB.
I accidentally disabled the Windows login user and now I can't log in anymore.
I also can't log in with the user "sa" nor do I know any other user.
How can I enable Windows user login again?
I'm waiting your feedback...
I would like to take this opportunity to wish you a good week.
My best regards,
Emanuel Delgado.
SQL Server | Other
14,494 questions
1 answer
Sort by: Most helpful
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2023-09-11T21:15:13.64+00:00