'sa' account is locked out - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

'sa' account is locked out

Author

Topic

ldodson
Starting Member

3 Posts

Posted - 2008-06-19 : 09:14:30

My 'sa' account is locked out and the BUILTIN\Administrators account does not have the sysadmin role. I removed the sysadmin role from BUILTIN\Administrators for security reasons and before I could create a new account with the sysadmin role I fat fingered the sa password and locked it out. How can I get myself out of this mess.

Any help would be welcomed.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-19 : 09:22:34

SA account is not a Windows account.
How can that account be "locked out"?

E 12°55'05.25"
N 56°04'39.16"

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-19 : 09:24:17

How your Sa account got locked out?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-19 : 09:32:04

You can alter the SQL Server to accept "mixed mode" of authentication. Then SA can log in again.

E 12°55'05.25"
N 56°04'39.16"

mdubey
Posting Yak Master

133 Posts

Posted - 2008-06-19 : 10:10:15

Is your server in Windows Authontication? It has to be on Mixed mode then you could use both SQL(SA) and Windows a/c.

Manoj
MCP, MCTS

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2008-06-19 : 10:37:31

I think he meant he has changed the SA password and couldn't remember it anymore since it was an accident.

If you removed the builtin account and have not added the service account in your login, try looking into using DAC instead. Assuming you didn't remove the network default account as well.

Or better, add yourself into the other default groups on the sql server when you first installed (if you haven't removed them as well)

HTH

quote:
Originally posted by mdubey

Is your server in Windows Authontication? It has to be on Mixed mode then you could use both SQL(SA) and Windows a/c.

Manoj
MCP, MCTS

--------------------
keeping it simple...

ldodson
Starting Member

3 Posts

Posted - 2008-06-19 : 10:39:00

This is sql 2005, it is in mixed mode. The problem is I removed the sysadmin role from BUILTIN\Administrators for security reasons and before I could create a new account with the sysadmin role I fat fingered the sa password and locked it out.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-19 : 10:53:43

Did you look what Jen said?

ldodson
Starting Member

3 Posts

Posted - 2008-06-19 : 10:56:27

What is DAC. Also I am in the Domain Admin group.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-19 : 11:06:33

To change authentication mode, see http://weblogs.sqlteam.com/peterl/archive/2008/06/19/How-to-change-authentication-mode-in-SQL-Server.aspx