BUILTIN\Administrator on SYSADMIN Role for SQL7
This is a discussion about BUILTIN\Administrator on SYSADMIN Role for SQL7 in the Windows Software category; 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.
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
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
Participate in our website and join the conversation
This subject has been archived. New comments and votes cannot be submitted.
Responses to this topic
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
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
