“Retrieving the COM class factory for component…. error: 80070005 Access is denied.” (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

by
  1. Make sure that you have Office runtime installed on the server.
  2. If you are using Windows Server 2008 then using office interops is a lenghty configuration and here are the steps.

Better is to move to Open XML or you can configure as below

  • Install MS Office Pro Latest (I used 2010 Pro)
  • Create User ExcelUser. Assign WordUser with Admin Group
  • Go to Computer -> Manage
  • Add User with below options
  • User Options Password Never Expires
  • Password Cannot Be Change

Com+ Configuration

  • Go to Control Panel – > Administrator -> Component Services -> DCOM Config
  • Open Microsoft Word 97 – 2003 Properties
  • General -> Authentication Level : None
  • Security -> Customize all 3 permissions to allow everyone
  • Identity -> This User -> Use ExcelUser /password
  • Launch the Excel App to make sure everything is fine

3.Change the security settings of Microsoft Excel Application in DCOM Config.

Controlpanel –> Administrative tools–>Component Services –>computers –> myComputer –>DCOM Config –> Microsoft Excel Application.

Right click to get properties dialog. Go to Security tab and customize permissions

See the posts here: Error while creating Excel object , Excel manipulations in WCF using COM

More Related Contents:

  1. Best way to run scheduled tasks [closed]
  2. What causes an application pool in IIS to recycle?
  3. Access-control-allow-origin with multiple domains
  4. Where does Console.WriteLine go in ASP.NET?
  5. What are all the user accounts for IIS/ASP.NET and how do they differ?
  6. Losing Session State
  7. HTTP Error 503, the service is unavailable
  8. IIS7 Cache-Control
  9. ASP.NET Web API OperationCanceledException when browser cancels the request
  10. HTTP Error 403.14 – Forbidden – The Web server is configured to not list the contents of this directory
  11. IIS Request Timeout on long ASP.NET operation
  12. IIS: Idle Timeout vs Recycle
  13. How can I share a session across multiple subdomains in ASP.NET?
  14. IIS URL Rewriting vs URL Routing
  15. How to keep ASP.NET assemblies in AppDomain alive?
  16. Preventing CSRF with the same-site cookie attribute
  17. How to warm up an ASP.NET MVC application on IIS 7.5?
  18. HTTP Error 500.22 – Internal Server Error (An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode.)
  19. Caching specific Javascript and CSS files
  20. NuGet: ‘X’ already has a dependency defined for ‘Y’
  21. How is ASP.NET multithreaded?
  22. How to deliver big files in ASP.NET Response?
  23. double escape sequence inside a url : The request filtering module is configured to deny a request that contains a double escape sequence
  24. IIS7 – The request filtering module is configured to deny a request that exceeds the request content length
  25. ASP.NET 5 project hosting on IIS
  26. Script not served by static file handler on IIS7.5
  27. What does ‘IISReset’ do?
  28. SignalR and Browser Connection limit
  29. What is an IIS application pool?
  30. How do I make a “generic error” page in my ASP.NET application so that it handles errors triggered when serving that page itself?

Leave a Comment