Re: Builtin Administrators Group and SQL Agent Jobs

From: Matt Troska (matt.troska_at_co.mcleod.mn.us)
Date: 10/31/03 

Date: Fri, 31 Oct 2003 08:42:26 -0800

All jobs are owned by SA and the problem remains.

>-----Original Message-----
>if possible, try changing the job owners to "sa" or an
appropriate non-NT
>account.
>
>
>--
>Kevin Connell, MCDBA
>--------------------------------------------------
>The views expressed here are my own
>and not of my employer.
>----------------------------------------------------
>"Matt Troska" <matt.troska@co.mcleod.mn.us> wrote in
message
>news:0b5401c39fca$6b8cddf0$a601280a@phx.gbl...
>> On my SQL 2k Server I added a SQL Login for a Domain
group
>> for DBA's and gave that login full access to all SQL
>> DB's. The DBA group is a member of the local
>> administrators group as well.
>>
>> I then removed the builtin\administrators group login
from
>> SQL Logins.
>>
>> SQL Server and SQL Agent are both started by a user that
>> is a member of the DBA group.
>>
>> After I did all of the above, my SQL Agent Jobs no
longer
>> seem to work. What happens is the jobs "execute" but
>> don't actually exeute. The jobs don't fail, but yet
they
>> don't complete either. SQL is installed in Mixed mode
and
>> all jobs are owned by SA.
>>
>> I have tried recreating the jobs and that did not seem
to
>> help.
>>
>> I added the builtin\administrators group as a SQL login
>> and the started to work.
>>
>> I need to remove the builtin\administrators as a SQL
login
>> to restrick access to some of the DB's.
>>
>> Thanks.
>>
>> Matt
>
>
>.
>

Relevant Pages

  • Re: procedure & function inside packages
    ... SQL> create table jobs ( ... SQL> CREATE OR REPLACE PACKAGE job_pkg IS ... SQL> CREATE OR REPLACE PACKAGE BODY job_pkg IS ... 'Chicken tickler') ...
    (comp.databases.oracle.server)
  • Re: Builtin Administrators Group and SQL Agent Jobs
    ... has the service acct which sqlagent and sqlserver run been given the ... > All jobs are owned by SA and the problem remains. ... >>> On my SQL 2k Server I added a SQL Login for a Domain> group ...
    (microsoft.public.sqlserver.security)
  • Re: SQL performance - multiple rows for SELECT (SQL0811)
    ... straightforward with SQL. ... SELECT aaa into:var from filea ... UPDATE fileb set xxx = 123 ... some high-volume batch jobs that have lots of embedded ...
    (comp.sys.ibm.as400.misc)
  • Re: procedure & function inside packages
    ... INSERT INTO jobs ... SQL> CREATE OR REPLACE PACKAGE job_pkg IS ... SQL> CREATE OR REPLACE PACKAGE BODY job_pkg IS ... 'Chicken tickler') ...
    (comp.databases.oracle.server)
  • Re: Builtin Administrators Group and SQL Agent Jobs
    ... > On my SQL 2k Server I added a SQL Login for a Domain group> for DBA's and gave that login full access to all SQL> DB's. ... > SQL Server and SQL Agent are both started by a user that> is a member of the DBA group. ... What happens is the jobs "execute" but> don't actually exeute. ...
    (microsoft.public.sqlserver.security)