[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 948
  • Last Modified:

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.
0
rkeith2412
Asked:
rkeith2412
  • 2
1 Solution
 
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
 
Anthony PerkinsCommented:
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
 
rkeith2412Author Commented:
Re-install did it, shame there isn't a better way.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now