Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change the Service accoutn to get SQl instance access Expand / Collapse
Author
Message
Posted Tuesday, December 7, 2010 7:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 11:38 AM
Points: 66, Visits: 430
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
Posted Wednesday, December 8, 2010 8:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 1, 2014 1:35 AM
Points: 42, Visits: 399
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
Posted Saturday, December 11, 2010 5:07 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:00 PM
Points: 1,194, Visits: 2,226
Follow EvilDbas great advice. That will work.

Thank You,

Best Regards,
SQLBuddy.
Post #1033401
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse