Post reply

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

  • January 14, 2011 at 11:49 am

    #388641

    Hello all,

    I hope you can help me. I'm running SQL Server 2005 on Windows Server 2003. I accidentally deleted the SQL Server login BUILTIN\Administrators. All logins except sa disappeared. So I need to restore the master database, but the sa password isn't working. I'm still connected with my domain account, but I think I now have only public access. How can I restore the master database?

    -- Beth

  • 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 3 posts - 1 through 3 (of 3 total)

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