October 21, 2008 at 6:31 am
User SA lock, even using mixed mode of authentication can not release the user.
Please help me.
October 21, 2008 at 7:55 pm
Has the sa login been disabled? If not, then does it have Password Policy enforced checked?
K. Brian Kelley
@kbriankelley
October 21, 2008 at 8:49 pm
What does release mean? Please explain what you are trying to do and what is happening in more detail.
October 21, 2008 at 9:29 pm
changed the password for the sa user, but forgot to lock the account and just, after changing the mode of authentication for mixed mode, it even as administrator of the windows, I can not do anything in SQL Server. Not have permission to release the sa account, and can not do any update in the configurations of the master instance.
It seems that the SA account is disabled and so I am able to connect to the bank consultations.
How can I make the permissions and release the SA account.
Please help me, this bank is already in production.
Thank you
October 21, 2008 at 11:04 pm
Hi,
You have specified that you changed the password for sa and forgot to disable which means you remember the password for sa correct?
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
October 22, 2008 at 5:52 am
It sounds like BUILTIN\Administrators was removed from SQL Server. If you can log on to the server, whether at the console or through terminal services, there is a way to get into SQL Server, add a Windows group or reset the SA password (and unlock the account), and then be able to access SQL Server normally again. It will require you to take SQL Server off-line, however. Here are the instructions on how to do this:
K. Brian Kelley
@kbriankelley
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply