locked
SQL job failed to complete RRS feed

  • Question

  • I have a problem getting the "Microsoft Forefront Client Security" SQL Agent job to complete sucessfully.  I get the error pasted below.  I have confirmed that my SQL Server Agent service account (domain user) has full control access to all the SQL databases (in SQL and at the Windows level).  If I make my SQL server agent service account a local administrator then the job completes sucessfully.  Is that a requirement for FCS?  Thanks!

    Date  12/8/2008 1:19:31 PM
    Log  Job History (Microsoft Forefront Client Security)

    Step ID  1
    Server  %computername%
    Job Name  Microsoft Forefront Client Security
    Step Name  Microsoft Forefront Client Security
    Duration  00:00:00
    Sql Severity  0
    Sql Message ID  0
    Operator Emailed  
    Operator Net sent  
    Operator Paged  
    Retries Attempted  0

    Message
    Executed as user: domain\serviceaccount. ...rt:  DTSStep_DTSDynamicPropertiesTask_1   DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_1   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_2   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_2   DTSRun OnStart:  DTSStep_DTSTransferObjectsTask_1   DTSRun OnProgress:  DTSStep_DTSTransferObjectsTask_1; Scripting objects for Transfer; PercentComplete = 0; ProgressCount = 0   DTSRun OnError:  DTSStep_DTSTransferObjectsTask_1, Error = -2147221504 (80040000)      Error string:  Invalid OLEVERB structure         Error source:  Microsoft Data Transformation Services (DTS) Package      Help file:  sqldts80.hlp      Help context:  1100      Error Detail Records:      Error:  -2147221504 (80040000); Provider Error:  0 (0)      Error string:  Invalid OLEVERB structure         Error source:  Microsoft Data Transformation Services (DTS) Package      Help file:  sqldts80.hlp      Help context:  1100         Error:  -2147221504 (80040000); Prov...  Process Exit Code 1.  The step failed.

    Monday, December 8, 2008 7:31 PM