sa accouint locked and the BUILTIN\Administrators account does not have the sysadmin role

Question

Post reply

sa accouint locked and the BUILTIN\Administrators account does not have the sysadmin role

ldodson

Grasshopper

Points: 17
More actions
June 12, 2008 at 12:21 pm

#121959

sa accouint locked and the BUILTIN\Administrators account does not have the sysadmin role
HELP PLEASE........................

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114704 More actions · Answer 1

Here's how to recover. It'll require you to bring your SQL Server off-line:

Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005

K. Brian Kelley
@kbriankelley

ldodson Grasshopper Points: 17 More actions · Answer 2

Mr. Kelley,

Thank you for the Disaster Recovery document. I tried it last night from home but had little success. I made the change in the Configuration Manager OK and restarted the instance in single-user mode. After that no luck. When I tried to connect to the server with the server admin account in Management studio it said it was already opened in single-user mode, the same with sqlcmd. Is there some other changes needed in Configuration manager / advance tab? Is there more documentation? I did make a change to start sql server manually but that didn't work because it said you couldn't do it remotely. Any additional help would be greatly appreciated. Thanks

K. Brian Kelley SSC Guru Points: 114704 More actions · Answer 3

You may have to disable the network libraries temporarily so that the only connection that can be made is from the local server. You can do that through SQL Server Configuration Manager, but remember what your settings were. Also, are there any apps running locally (like SQL Server Reporting Services) that makes connections in? If so, you may have to ensure they aren't running (or their service isn't running, as is the case with SSRS).

K. Brian Kelley
@kbriankelley

ldodson Grasshopper Points: 17 More actions · Answer 4

Can this be done remotely or should I be on the server? Can I do it within Management studio?

K. Brian Kelley SSC Guru Points: 114704 More actions · Answer 5

It can be done remotely, but if you disable the network libraries, you will have to do it local.

SSMS can do it, but you can't make the initial connection with object explorer because that takes up 1 connection. That's why SQLCMD is preferred.

K. Brian Kelley
@kbriankelley