SQL 2008 R2 Express with sa account locked out

I have an install of SQL 2008 R2 Express with a major issue.  The only sysadmin account is SA and that has been locked out.  the only other login is BUILTIN\Users with public access.  I have tried using the -m switch but when I try to use SQLCMD to login I get an error "Msg 18461, Level 14, State 1, Server SERVER1\SQLEXPRESS, Line 1 Login failed for user DOMAIN\user'. Reason: Server is in single user mode. Only one administrator can connect at this time." and I am the only trying to connect.  I have tried this with both a Domain Admin account as well as the local admin account.
LVL 5
rkeith2412Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Anthony PerkinsConnect With a Mentor Commented:
I have an install of SQL 2008 R2 Express with a major issue.  The only sysadmin account is SA and that has been locked out.  the only other login is BUILTIN\Users with public access.
You will have to re-install SQL Server Express.
0
 
QPRCommented:
The -m option is putting it into single user mode

Check this post for a few ideas
http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/16706dec-209f-42c4-8dc7-4ee4dd5df482/
0
 
rkeith2412Author Commented:
This doesn't work, SA is the only sysadmin on the server and that account is locked out.  I need a way to unlock it without having any other user having access either.
0
 
rkeith2412Author Commented:
Re-install did it, shame there isn't a better way.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.