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

Popular posts from this blog

OpenCover code coverage for .Net Core

ionic2 cordova build android - Unable resolve gradle 2.2.3

Using Custom DLL with IronPython / Scripts