WMI and Scheduled Job

• dkhattar

  SSCrazy

  Points: 2037

  More actions

  July 31, 2007 at 6:36 am

  #125137

  Hi,

  I have a SSIS package which uses WMI Reader Task to get server info viz. disk space, services running etc from 30 server.

  Package runs fine  when executed manually locally from server using Management studio  but fails when run as scheduled job. Following message is logged.

  OnError,SQLService,WMI Data Reader Task,{DBAE4589-A34E-4D83-8CCB-C8C893AC4656},{9996C8D9-A605-44BC-8F52-0BF4CAEB272E},7/31/2007 1:17:37 PM,7/31/2007 1:17:37 PM,-1073548540,0x,An error occurred with the following error message: "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))".

  Added sql agent service account to  DCOM --> WMI ... but of no use.. Any idea?

  Cheers

  Deepak

   

   

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  July 31, 2007 at 7:24 am

  #723557

  Have you attempted to create a new credential and execute the job under this account? Refer to "Credential Properties (General Page)" in BOL.

  Tommy

  Follow @sqlscribe