tommyh
asked on
sa password been reset and BUILTIN/Administrator has been removed from sysadmin group
A SQL SERVER 7 machine on my network was used and abused by a user, who reset the sa password and removed the NT/Administrator user from the SQL server sysadmins group, rendering it inaccessable to any sysadmins.
How can I get sysadmin privileges back on the sql server?
I have tried,
1) starting it in single user mode and trying to connect to it. (i think there is some scope for more investigation here, but im not sure what to try)
2) trying to connect to it using NT privileges.
3) a brute force sa password hack - but this was only check 5 passwords a second, and would have taken many years to get to 8 chars
I can stop the service and copy the mdf and ldf files to another machine and restore them, but then I'm going to end up with the same problem on another machine.
Is there any way I can extract or reset the sa password to blank using a utility?
Many thanks.
Tom H
How can I get sysadmin privileges back on the sql server?
I have tried,
1) starting it in single user mode and trying to connect to it. (i think there is some scope for more investigation here, but im not sure what to try)
2) trying to connect to it using NT privileges.
3) a brute force sa password hack - but this was only check 5 passwords a second, and would have taken many years to get to 8 chars
I can stop the service and copy the mdf and ldf files to another machine and restore them, but then I'm going to end up with the same problem on another machine.
Is there any way I can extract or reset the sa password to blank using a utility?
Many thanks.
Tom H
ASKER
surely this will reinstall the master database, thus destroying all of my logins.
plus I can't login at the moment, so I can't make any backups.
plus I can't login at the moment, so I can't make any backups.
ASKER
surely this will reinstall the master database, thus destroying all of my logins.
plus I can't login at the moment, so I can't make any backups.
plus I can't login at the moment, so I can't make any backups.
ASKER
surely this will reinstall the master database, thus destroying all of my logins.
plus I can't login at the moment, so I can't make any backups.
plus I can't login at the moment, so I can't make any backups.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Unfortunately I don't have an account available with backup privileges, and the scheduled maintentaince has packed up. I was trying to detach and reattach the database files but according to the documentation for both sp_attach_single_file_db and sp_attach_db, they both need to be used on previously detached databases.
In the current situation I definitely can't get sysadmin privileges to execute the sp_detach_db stored procedure.
Any ideas on reattaching undetached databases?
tommyh:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
Good luck!