Share via

How to reset main account, or restart SQL Server on my system entirely.

Stefan Novak 46 Reputation points
2021-02-06T16:41:21.803+00:00

Hey all,

I mistakenly locked myself out of my SQL Server. I'm new to using this software and as I was playing about exploring SSMS I accidentally locked myself out of the database, and now I'm at a point where I can do absolutely nothing.

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

I'm using Windows Authentication to sign in, and the server name is my own name, I don't remember setting any of this up so I am totally locked out. I used the sa account once before many years ago but by this point I can't remember that password. I tried this 'solution' where I used the Sql Server Configuration Manager, ran the thing in single user mode or something and tried to reset but no success.

Does anyone have any help for me? Or am I just going to have to completely reset everything to factory settings

Cheers

SQL Server | Other
0 comments
Accepted answer
  1. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    2021-02-06T17:27:05.593+00:00

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.