Removing BUILTIN/Administrators causes clustered SQL 2000 jobs to fail

Similar, but different, to a previous question asked about removing builtin/admin from a 2005 instance (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23142739.html), I attempted to remove the builtin/admin user from a 2000 clustered instance and it caused the jobs to fail. The clustered jobs are owned by the same domain admin account that the agent services is running. How do I remove the builtin/admin account without effecting the jobs?
barnescoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chapmandewCommented:
They may be owned by them, but are they running under the account you have removed?  Open up the job and see who they are running under.  You may need to add teh account back, but remove any admin permissions.
0
barnescoAuthor Commented:
The job is owned by the domain admin account, not the buitin/admin account. SQL agent is also running under the same domain admin account.

I could change the owner of the jobs to another SA account. Could that work? Unfortunately, I can't "play" with process too much...it's a heavy prod server.
0
chapmandewCommented:
Yes, it is worth a shot if they are failing.  Switch the owner to SA.
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

barnescoAuthor Commented:
The problem I'm having now is that builtin\admin is a dbo owner, yet all the databases show they're owned by SA. I even tried resetting sp_changedbowner to SA again, but the when I attempt to remove the builtin\admin I receive the error message: The database owner cannot be dropped. Also, if I attempt to remove the dbo role from builtin\admin, I get the message Error 15405: Cannot use the reserved user or role name dbo.
0
chapmandewCommented:
Don't remove the account then.  Just remove all privledges from the account.  That is what we did on our cluster...I think the cluster uses that account.
0
barnescoAuthor Commented:
Thanks. I removed sysadmin rights for builtin, but all the jobs still fail despite using sa as the owner.
0
chapmandewCommented:
So, what is the reason they are failing for?  If you look at the history of the job it should give you some sort of description why it is failing.
0
barnescoAuthor Commented:
I think I found the reason. The builtin\amdin, when it was originally setup in the clustered group, has something to do with the "IsAlive" check:

http://support.microsoft.com/kb/291255
http://support.microsoft.com/kb/263712/EN-US/

I'm not sure what to do at this point. I'll have to research this further. Any suggestions?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chapmandewCommented:
So, is it a big deal if that user accounts remains as an admin?  I wouldn't think that it would be, as long as the network admins keep a pretty tight control over who are admins on the network.
0
barnescoAuthor Commented:
Yes. It's huge.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.