November 2012 - Posts

You couldn't write it - Expired SA account

This is the stuff of DBA nightmares !

email trail:

Q. Can you reset the SA account on server XXXXX, we think it has expired and now no-one can work.

Connect to Server:
Surely no-one would set up a Server with an sa account which expires?
Thankfully not.
Find sa password and change connection to use SA account.
Connect without issue.

Me. Have checked Server and account is fine.

A. Thanks that's great, you've fixed it we can all work now.

Posted by GrumpyOldDBA with no comments
Filed under: