This question already has an answer here:
I need to recover my SQL Server 2008 user/pwd.
The situation is: I don't know the
SA password and Windows Authenticated user is no longer active user (disable user because the user has left job) so I can not log in using Windows authentication.
Is there anyway to reset the
sa password, Windows authentication and to log in to the database?
Last option could be uninstall and install again. In this case data will be lost.