SQL 2005 sa account is locked out

[web4fun]

Need some desperate assistance...we don't have a local SYSADMIN SQL login nor do we have BUILTIN\Administrators with any access and now the 'sa' account is locked out.

Please assist

 

[mrdenny]

If you do not have any accounts with sysadmin rights and the sa account has become locked there isn't much you can do.

I assume that it was locked because someone tried to log in with the wrong password to many times and the SQL Server locked the account per the domain security policy?

Or did someone manually lock the account?

If the SQL Server runs under a Windows account that account probably has sysadmin rights to the SQL Server and you should be able to log in with that account.

If you run under the local system account, and the sa account was manually disabled then you may be reinstalling the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[web4fun]

Mr Denny...thanks as usual for the information. Yes, someone did manually disable the account mistakenly and SQL Server is running under the local system account. Luckily we tracked down the user who made the error who had added himself as a 'sysadmin' so we used his login to unlock the account....so goes the pains of remote sites at small companies that we're in the process of taking over their IT related functions. Thanks again.

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com