6
Vote

Component does not seem to work with SQL server Agent

description

Hi guys,

I can't seem to get the refresh component working with the SQL server agent. I have tried it with SQL Server 2012 and 2014. Packages run succesfully in VS both 2010 and 2012.

This is the error message i am receiving:

Message:
Refresh Microsoft Excel Task:Error: The Execute method on the task returned error code 0x80070005 (Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).). The Execute method must succeed, and indicate the result using an "out" parameter.

If anyone could help me out:)

comments

nyiko4me wrote Apr 23, 2015 at 1:22 PM

Hi
I Had the same error and resolved it this way
Step 1
1) Start > Run > dcomcnfg
2) Navigate to Component Services > Computers > My Computer
3) Go to properties then select Com Security tab,
4) click on the edit button and give the user your SQL Agent is running on Access and Launch Permissions.
Step 2
Component services > Computers > My Computer > DCOM Config >Microsoft Excel application > properties > Identity Tab > Select the Interactive User > Ok.

wrote Jul 29, 2015 at 8:21 AM

wrote Jun 14, 2016 at 8:16 AM

wrote Jul 6 at 3:45 PM