Re: SQL Agent Jobs Failing
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/01/05
- Next message: Jluo: "Re: Update 300 DBs with .sql file"
- Previous message: Tibor Karaszi: "Re: Renaming the server and jobs"
- In reply to: J.Jill: "SQL Agent Jobs Failing"
- Next in thread: J.Jill: "Re: SQL Agent Jobs Failing"
- Reply: J.Jill: "Re: SQL Agent Jobs Failing"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Mar 2005 18:06:21 +0100
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 >
- Next message: Jluo: "Re: Update 300 DBs with .sql file"
- Previous message: Tibor Karaszi: "Re: Renaming the server and jobs"
- In reply to: J.Jill: "SQL Agent Jobs Failing"
- Next in thread: J.Jill: "Re: SQL Agent Jobs Failing"
- Reply: J.Jill: "Re: SQL Agent Jobs Failing"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
