Change the Service accoutn to get SQl instance access

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Change the Service accoutn to get SQl...

Change the Service accoutn to get SQl instance access

Rate Topic

Display Mode

Topic Options

Author

Message

wannabe dba

Posted Tuesday, December 07, 2010 7:58 AM

Valued Member

Group: General Forum Members
Last Login: Today @ 10:52 AM
Points: 66, Visits: 364

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

Post #1031229

iaminyourhead

Posted Wednesday, December 08, 2010 8:36 AM

SSC Rookie

Group: General Forum Members
Last Login: Sunday, April 28, 2013 11:48 AM
Points: 28, Visits: 307

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)

Post #1031924

sqlbuddy123

Posted Saturday, December 11, 2010 5:07 PM

Right there with Babe

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 11:49 AM
Points: 715, Visits: 1,523

Follow EvilDbas great advice. That will work.

Thank You,

Best Regards,
SQLBuddy.

Post #1033401

« Prev Topic | Next Topic »

Permissions