Dropping BUILTIN\Administorors problem

Last Post 11 Jan 2010 05:56 AM by Markus_SQL. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Markus_SQL
New Member
New Member

--
06 Jan 2010 05:51 AM
If I drop the BUILTIN\Administorators ID jobs that are owned by an ADirectory ID won't run via SQL Agent. The ID is the ID that installed and runs SQL Server and has 'sa' rights. If I add the BUILTIN\Administors ID Back into SQL Server the jobs run fine. Any ideas?

J013-B
New Member
New Member

--
07 Jan 2010 12:16 PM
Why not change the owner of the job to a user defined in the sysadmin role, and then try taking out builtin\Administrators?
Markus_SQL
New Member
New Member

--
08 Jan 2010 06:31 AM
I did and that does work. However, the question remains why doesn't an AD ID work though?
Markus_SQL
New Member
New Member

--
11 Jan 2010 05:56 AM
But the ID has 'sa' rights and is running SQL Server. It is an admin ID by definition of being 'sa'.


Acceptable Use Policy
---