|
Posted by Greg D. Moore \(Strider\) on 10/07/34 11:26
"Trevor Best" <googlegroups@besty.org.uk> wrote in message
news:1126541866.564969.175060@g14g2000cwa.googlegroups.com...
> Thanks, I've read the links you provided but none have helped.
>
> I can actually run the plan from an NT command prompt window and the
> backup runs OK and the plan exits with code 0 (success).
>
> It's just running from the SQLAgent or from Query analyser it fails
> immediately without having done anything. It's as though it just can't
> execute sqlmaint.exe. I can run other xps such as xp_msver without
> trouble so I'm sure the paths are correct.
>
> I checked HKLM\SOFTWARE\Microsoft\MSSQLServer\Setup (not where the
> first link says it is) and the path is set correctly.
Almot definitely then SQLAgent is NOT running under a domain account that
has access to the path you're specifying.
>
Navigation:
[Reply to this message]
|