The Multifunctioning DBA

Jan 28 2011   2:11AM GMT

Disabled SA account

Colin Smith Colin Smith Profile: Colin Smith

I recently had a situation where something happened to my SQL Server and I could no longer log in using windows authentication. I will get more into what happened in another post. Let me just preface all this by saying that I inherited this mess. Anyway, thanks to @afernandez and @banerjeeamit on twitter, and the article here explaining how to enable sa, I was able to get the sa account up, change the password, and then log in as sa to do what I needed to do. So thanks to all on #sqlhelp on twitter and if you are not on twitter yet DO IT!.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: