Skip to main content
Post Closed as "Duplicate" by Paul White
added 36 characters in body
Source Link
Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619

My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.

UPDATE

Tried login I tried logging in Single Userusing single user mode

But error shows as

Login failed for user 'SERVER\Administrator'. Reason: The account is disabled. (Microsoft SQL Server, Error Remus described but I get the following error: 18470)

Login failed for user 'SERVER\Administrator'.
Reason: The account is disabled.
(Microsoft SQL Server, Error: 18470)

My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.

UPDATE

Tried login in Single User mode

But error shows as

Login failed for user 'SERVER\Administrator'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)

My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.

I tried logging in using single user mode as Remus described but I get the following error:

Login failed for user 'SERVER\Administrator'.
Reason: The account is disabled.
(Microsoft SQL Server, Error: 18470)

edited tags
Link
Jon Seigel
  • 16.9k
  • 6
  • 45
  • 84
Post Migrated Here from stackoverflow.com (revisions)
Source Link

Re enable Windows Authetication in SQL Server

My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.

UPDATE

Tried login in Single User mode

But error shows as

Login failed for user 'SERVER\Administrator'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)