Post reply

Change the Service accoutn to get SQl instance access

  • December 7, 2010 at 7:58 am

    #388383

    Hi ,

    I got server admin access to a new bow which has a sql instance.Unfortunately nobody knows the sa password,also no other windows account has sysadmin either .There is one account which has db_owner on all the databases but nothing more .

    Is it possible to get admin access to the SQL instance if I change the account under which the SQL engine runs to my windows account?Will that give me sysadmin access?If this won't work is there any other way I can get into the sql instance?

    Thanks in advance

  • December 8, 2010 at 8:36 am

    #1260124

    1. I assume you're local admin group of server.

    2. RDP to the server.

    3. On command prompt NET STOP MSSQLSERVER (stop sql server)

    4. On command prompt NET START MSSQLSERVER /m (start server in single user mode)

    5. Now login to SQL server.

    6. Created a new login on SQL server and make it as SYSADMIN.

    7. Exit from sql server.

    8. NET STOP MSSQLSERVER (stop sql server)

    9. NET START MSSQLSERVER (start sql server)

  • December 11, 2010 at 5:07 pm

    #1261355

    Follow EvilDbas great advice. That will work.

    Thank You,

    Best Regards,

    SQLBuddy.

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

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