Re: SQL Agent Jobs Failing

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: J.Jill (JJill_at_discussions.microsoft.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 10:11:03 -0800

sorry, "SA" is not an option.

bill

"Tibor Karaszi" wrote:

> Is changing the job owner to "sa" an option? That will most probably solve the problem.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
>
> "J.Jill" <JJill@discussions.microsoft.com> wrote in message
> news:59173D5F-9F15-49B8-95F2-42078CAC5437@microsoft.com...
> >I have a number of job failing due to authentication issues.
> > enviroment
> > 2003 Standard Edition
> > SQL 2000 Service Pack 3
> > 2003 Active Directory Domain
> > SQL Agent runs under a domain account with sysadmin rights
> > Job owner is also a domain account with sysadmin rights
> >
> > The jobs run succesfully sometimes and fail other times.
> > Error:
> > Number 1 from Agent error log.
> > [298] SQLServer Error: 8198, Could not obtain information about Windows NT
> > group/user 'webad\mysqlagent'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
> >
> > Number 2 from the job history log
> > The job failed. Unable to determine if the owner (WEBAD\myuser) of job
> > myjobName has server access (reason: Could not obtain information about
> > Windows NT group/user 'WEBAD\myuser'. [SQLSTATE 42000] (Error 8198)).
> >
> > Thank you..
> > Bill
> >
>
>
>

Relevant Pages

  • Re: 64bit insert delays
    ... Tibor Karaszi, SQL Server MVP ... > we/users can query when mails were processed by the antispam system, ... this sounds like you are selecting from some other table than the one inserting into and you ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Truncating Log Files
    ... Tibor Karaszi, SQL Server MVP ... I have ran dbcc loginfoand used found that I have about 136 Gig at ... my LSN for Log Shipping and possibly break my Mirroring? ...
    (microsoft.public.sqlserver.server)
  • Re: Subquerie in CHECK Constrain
    ... I recall once retrieving a record set in VB, looping it and for each row, executing another ... Tibor Karaszi, SQL Server MVP ... >> Kalen Delaney ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: errr........getdate within a function.
    ... Tibor Karaszi, SQL Server MVP ... "Jacco Schalkwijk" wrote in message ... >> CREATE FUNCTION foo1RETURNS datetime AS ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Maintenance did not delete old files
    ... The last thing I'd triple check is the configuration regarding recurs subfolders, ... Tibor Karaszi, SQL Server MVP ... Yes, I did the maintenance plan in a well design, the same maintenance plan on another PC running well on developer edition but not on standard edition. ...
    (microsoft.public.sqlserver.server)