Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.

share|improve this question
    
What do you mean, Windows Authentication was disabled? In SQL Server, you have two options for authentication: Windows Auth or Windows and SQL Auth. –  Thomas Stringer May 17 '13 at 12:48
    
@ThomasStringer Windows Administrator login was removed. –  Akhil K Nambiar May 17 '13 at 12:49
2  
Ok. If you are a local administrator on the machine, start SQL Server in single user mode (-m) and connect to reset the sa password. –  Thomas Stringer May 17 '13 at 12:50
1  
1  
exact duplicate stackoverflow.com/questions/16608997/… –  Remus Rusanu May 17 '13 at 13:07
show 12 more comments

closed as off topic by JNK May 17 '13 at 13:12

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.