Re: Weird SQL Server 2000 behavior in Transaction Log Shipping



Can you please check the job owner is sa and then start the job - sometimes
this lack of response is due to the job owner not being validated in AD.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com


.



Relevant Pages

  • Re: Job owned by a non-sysadmin fails to run
    ... try temporarily changing the job owner to 'sa' as PSPDBA suggested. ... If the job still fails, then the problem is related to running as a job rather than a security issue. ... SQL Server MVP ... I definitely don't want to give users administrative privileges. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Agent Jobs Failing
    ... Is changing the job owner to "sa" an option? ... Tibor Karaszi, SQL Server MVP ... > SQL Agent runs under a domain account with sysadmin rights ...
    (microsoft.public.sqlserver.server)
  • Re: Error for a job that uses a MSDASQL linked server
    ... Tibor Karaszi, SQL Server MVP ... actual job owner? ... >>>>> When I execute the job I have had this error for the step ...
    (microsoft.public.sqlserver.server)
  • Re: MSDE and replication
    ... Thanks for the quick response. ... to set up a dummy subscriber using EM and then script it out. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)