Home / server / Questions / 487542
Accepted
Steve
Asked: 2013-03-14 10:22:49 +0800 CST

SQL Server account disabled even in single user mode

  • 772

I'm integrating with a third-party product via its SQL Server 2008 R2 database. In a previous version, I was able to access the database via SQL Server Management Studio and SQLCMD as a Windows administrator using Windows authentication.

The third-party product controls the sa account and keeps the password a secret.

After applying the vendor's latest product update, I can no longer access the database using Windows authentication. I even tried single mode, but no luck.

Here's how I switched to single mode:

net stop MSSQL$FOOBAR
net start MSSQL$FOOBAR -mSQLCMD

That seems to start the database.

C:\>sqlcmd /S .\FOOBAR
Msg 18470, Level 14, State 1, Server WINMAC\FOOBAR, Line 1
Login failed for user 'WINMAC\steve'. Reason: The account is disabled.

Is there a way in? Or is it more likely the vendor has closed a hole and I can't get in?

sql-server

1 Answers

  1. Best Answer

    Using PSExec to connect to an instance using the NT AUTHORITY\SYSTEM account:

    http://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/

    However bear in mind that you may be breaking some contract, just wanted to note it :)

    Original author is here

    • 1