Re: Builtin Administrators Group and SQL Agent Jobs

From: Kevin (ReplyTo_at_Newsgroups.only)
Date: 10/31/03 

Date: Fri, 31 Oct 2003 13:41:02 -0800

The only other thing I can think of is maybe to check the sqlagent error log
for errors. "SQLAGENT.OUT" in the log\ folder

if the service account has local admin, sysadmin, and the appropriate user
rights, then it should work. 

--
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:00a701c39fe6$56e3ccd0$a601280a@phx.gbl...
> I checked and 'Change a process level token' and 'Act as
> part of the OS' were not granted to the service account.
>
> I granted those rights to the account, but it still does
> not seem to be working correctly.
>
> Matt
>
>
> >-----Original Message-----
> >has the service acct which sqlagent and sqlserver run
> been given the
> >following rights?
> >
> >- Change a process level token
> >- Act as part of the OS
> >- Log on as a service
> >- Increase Quotas
> >
> >?
> >
> >
> >--
> >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:0cdf01c39fcd$f7715e60$a401280a@phx.gbl...
> >> 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: xp_cmdshell generates "Login failed for user SVCtoronto." when run in SQLAgent job.
    ... XP_Cmdshell is only available to SQL logins who are SQL administrators by ... and the security context that ALL xp_cmdshell jobs run under the ... sql logins, and provide a single NT login which will be used for the ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)
  • 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: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)