Post reply

Help! Need to restore master but can't log on

  • January 14, 2011 at 3:52 pm

    #1273839

    I figured it out. Turns out this is easy. Local admins on the server have sysadmin rights from sqlcmd when the database is in single-user mode. I was able to restore the master database using sqlcmd and Windows authentication.

  • January 16, 2011 at 7:29 am

    #1273980

    Beth Major-235285 (1/14/2011)

    I figured it out. Turns out this is easy. Local admins on the server have sysadmin rights from sqlcmd when the database is in single-user mode. I was able to restore the master database using sqlcmd and Windows authentication.

    or you could have re created the BUILTIN\Administrators login and put it back into sysadmins 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 2 posts - 1 through 3 (of 3 total)

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