Retrieving the COM class factory for component failed

Question

I am using an excel object  COM component  for excel manipulation  It works fine on my PC  but when I deploy the application to our Intranet I am getting this error      Retrieving the COM class factory for component with CLSID  00024500-0000-0000-C000-000000000046  failed due to the following error  80070005   I am using windows authentication and impersonate true in my web config   I made all the settings in component service but it still gives the same error   Please help

User · Answer

For IIS 8 I did basically the same thing as Monic. Im running my application as its own app pool on an x64 machine 1.In DCOMCNFG, right click on the My Computer and select properties.

2.Choose the COM Securities tab.

3.In Access Permissions, click Edit Defaults and add iis apppool\myapp to it and give it Allow local access permission. Do the same for iis apppool\myapp

4.In launch and Activation Permissions, click Edit Defaults and add iis apppool\myapp to it and give it Local launch and Local Activation permission. Do the same for iis apppool\myapp.

additionally I had to make the folders outlined under C:\Windows\SysWOW64\config\systemprofile\Desktop and give read \ write permissions to iis apppool\myapp also

User · Answer

There s one more issue you might need to address if you are using the Windows 2008 Server with IIS7  The server might report the following error   Microsoft Office Excel cannot access the file  c  temp test xls   There are several possible reasons    The file name or path does not exist  The file is being used by another program  The workbook you are trying to save has the same name as a currently open workbook    The solution is posted here  look for the text posted by user Ogawa   http   social msdn microsoft com Forums en-US innovateonoffice thread b81a3c4e-62db-488b-af06-44421818ef91 prof required

User · Answer

The CLSID you describe is for the Microsoft Office Interop Excel ApplicationClass   This class basically launches excel exe through InprocServer32   If you don t have it installed then it will return the error message you received above

User · Answer

I can understand your pain  In my case the error got resolved by performing below steps    Start   Run   dcomcnfg  Open the folder DCOM Config and Select Component Services   Computers   My Computer   DCOM Config  Select    Microsoft Office Word 97     2003 document       Microsoft Excel Application    and go to its properties  In  Security  tab set    Launch and Activation Permissions    need to be Customize  Authorized user   Now go to IIS and select application pool of the Web and go to its Advanced Settings and select    NETWORK SERVICE    as identity user    Hope this helps

User · Answer

You will also get this error when there are stale EXCEL EXE processes in the system  Use Task Manager -- gt  Processes tab to view these     Kill all those instances and the application would work normally

User · Answer

In case it helps somebody    I am running Windows 7 64-bit and I wanted to register a 32-bit dll    First I tried  regsvr32  and got the following error    System Runtime InteropServices COMException  0x80040154   Retrieving the COM class factory for component with CLSID  A1D59B81-C868-4F66-B58F-AC94A4A7982E  failed due to the following error  80040154    Then I tried to add the application through the Component Services  Run- DCCOMCNFG   http   www justskins com forums difference-registering-dll-using-regsvr32-and-component-services-17280 html  and got the following error    System UnauthorizedAccessException  Retrieving the COM class factory for component with CLSID  A1D59B81-C868-4F66-B58F-AC94A4A7982E  failed due to the following error  80070005   There are many links to solving it but what worked for me was   Console Root -  Component Services -  Computers -  My Computer -  COM  Applications -  your application name -  Properties  Security tab  Authorization  Uncheck  Enforce access checks for this application     I don t know what it does

User · Answer

I m getting this same error when trying to export a csv file from Act  to Excel  One workaround I found was to run Act  as an administrator  That tells me this is probably some sort of permission issue but none of the previous answers here solved the problem  I tried running DCOMCNFG and changing the permissions on the whole computer  and I also tried to just change permissions on the Excel component but it s not listed in DCOMCNFG on my Windows 10 Pro PC  Maybe this workaround will help someone until a better solution is found

User · Answer

I had the same error when I deployed my app  I ve got solution from this site  Component with CLSID XXX failed due to the following error  80070005 Access is denied  Here is this solution    In DCOMCNFG  right click on the My Computer and select properties   Choose the COM Securities tab  In Access Permissions  click Edit Defaults and add Network Service to it and give it Allow local access permission  Do the same for  lt  Machine name   Users  In Launch and Activation Permissions  click Edit Defaults and add Network Service to it and give it Local launch and Local Activation permission  Do the same for  lt  Machine name   Users     I used forms authentication

User · Answer

I have Done the Following Things in IIS 8 5  Windows Server 2012 R2 Server and its Worked in My Case Without Restart    Selecting The Application Pool That Connected to The Application in IIS And Right Click --  Advanced Settings --  Process Model --  Select Local System Instead of Recommended ApplicationPoolIdentity  And Make Sure C  Windows SysWOW64 config systemprofile desktop Have Enough Access For Users  Refresh the Website Link that Connected With this Pool

User · Answer

This did the trick for me   solution from the msdn forum   goto Controlpanel -- gt  Administrative tools-- gt Component Services -- gt computers -- gt  myComputer -- gt DCOM Config -- gt  Microsoft Excel Application  right click to get properties dialog  Goto Security tab and customize permissions accordingly   In Launch and Application Permissions  select Customize  Edit  Add the user   group that calls the application

[excel] Retrieving the COM class factory for component failed

Examples related to excel

Examples related to com