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) |
|