BUILTIN\Administrator on SYSADMIN Role for SQL7

Windows Software 5498 This topic was started by ITGL72, 2002-06-24 18:16

Discussion 1

6 Posts
Location -
Joined 2001-08-29

2002-06-24 20:16

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

Deleting Hardware Profile

ie down boy, down...

Participate on our website and join the conversation

You have already an account on our website? Use the link below to login.

Create a new user account. Registration is free and takes only a few seconds.

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

Uykucu

540 Posts
Location -
Joined 2001-02-28

#86609

2002-06-26 10:42

You are looking at a nice reinstall i am afraid.
One of my guys did that once, it took him the hall night to sort it. and he reinstalled in the end. Have you ever spent 7 hours between cabinets