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.


Popular posts from this blog

A quick tutorial for OWASP ZAP tool for beginners

ionic2 cordova build android - Unable resolve gradle 2.2.3