Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get sysadmin rights back !

Status
Not open for further replies.

swolfp

IS-IT--Management
Aug 15, 2002
5
GB
I've got a SQL 2000 server in windows only authentication, and I have removed the BuilIn/Administrators group from the sysadmin role.

I have tried logging in as SA but I get the message 'Not associated with a trusted SQL server connection'

Is there a way out of this ?
 
reinstall SQL, but select the "Upgrade" option
 
OK managed to get around the sa prob with a registry edit, then could go in as sa and fix.
Thanks anyway !
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top