MSSQL - Recovering user account when you accidentally delete relevant login account


I had the good experience of removing local domain account (windows authenticated user) from my mssql database and you guess it, i was not able to login at all using windows authenticated users.

Instead  of reinstall my database, here's what i did :-

a) stop "Sql Server (MSSQL Server service)

b) net start mssqlserver /m

c) fire up SQL Management studio and login using Windows Authentication.

d) Perform recovery process whereby you add relevant users accounts here.

e) Restart your MSSQL server service and login.

That's it.


Comments

Post a Comment

Popular posts from this blog

The specified initialization vector (IV) does not match the block size for this algorithm

Image
If you're getting  exception when trying to assigned key to a symmetric key and getting error message below :- The specified initialization vector (IV) does not match the block size for this algorithm And your code probably look like something below :- Then you need to go into debug mode and start looking into the supported size for IV as shown in diagram below :- As you can see, IV is 16 bytes, so you need to provide 16 bytes. The same goes for Key field too, if you're adding anything to it. As long as you provide a valid key size, then we're good and you're code will be ready.
Read more