[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 649
  • Last Modified:

BUILTIN\Administrator on SYSADMIN Role for SQL7



I was working on a fresh install of SQL7 SP4 on an NT4 SP6a server.
Going through the MBSA on some recommended fixes I removed the
BUILTIN\Administrator account from the SYSADMIN ROLE.

I guess the morning coffee had not kicked in yet.

The only thing that is in there is the "SA" account.

Well I'm a bit stuck now. I am hoping I do not have to reinstall SQL7.

I am unable to administer what I need to now on the SQL Server.

Can I get the BUILTIN\Administrator account back into the SYSADMIN ROLE,
or is there another route to take here?

Thanks!
-George

0
gplemos
Asked:
gplemos
1 Solution
 
Brendt HessSenior DBACommented:
Try this workaround:

1. Create a regular domain account, let's call it
mydomain\sqlexecutive.

2. Grant this account LOCAL admin rights on the server
where SQL Server is installed.  Also make sure that this
account has 'login as service' and 'run batch jobs'
advanced rights in NT.

3. Grant this account 'system admin' rights on the SQL
Server

4. Setup your services to use this account when starting.

0
 
gplemosAuthor Commented:
> 3. Grant this account 'system admin'
> rights on the SQL Server

How can I do this? The only user account on this machine now is my admin account. (Not in live environement right now.) I can't do anything unless I'm in or working as "SA" since thats the only thing left that has the sysadmin role?

I can do everything else you mentioned but step three has me confused?


0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
NetminderCommented:
Per recommendation, points refunded and question closed.

Netminder
CS Moderator
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now