Q
Problem solve Get help with specific problems with your technologies, process and projects.

Problems when sysadmin role removed from BUILTIN/Administrator

The BUILTIN/Administrator was given system admin role on creation of the database. Auditors have required us to remove the sysadmin role from this user but as I do that, the jobs/database maintenance jobs do not run. I get error 229 on all sys objects. The user for these jobs is NOT the BUILTIN/Administator, but another user. Why is this affecting these jobs?

There is a KB article at http://www.microsoft.com/technet that details how to remove the Administrator account and the permissions that need to be assigned to make sure everything will still work.

 

For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close