Access problem when calling Excel from a web application

[Gilbert Tordeur]

Hello,

My Web application in VB2008 with IIS calls Excel (2003) to create an Excel
file xls. I use therefore Microsoft.Office.Interop.Excel, version 11.

This application does not use anonymous connections; it automaticaly uses
the Windows userid.

On my development PC, with local server, everything is OK.

On a test server with IIS and Excel, my program gets an error on the first
statement related to Excel :
Dim ApplicationExcel As New Excel.Application

Error message: Retrieving the COM class factory for component with CLSID
{...} failed due to the following error : 80070005.
Explanations : ASP.NET is not authorized to access the requested resource.
Etc.

What access rights should I grant to what resources ?

Thank you for your help,
Gilbert

 

[Paul Montgumdrop]

Hello,

My Web application in VB2008 with IIS calls Excel (2003) to create an Excel
file xls. I use therefore Microsoft.Office.Interop.Excel, version 11.

This application does not use anonymous connections; it automaticaly uses
the Windows userid.

On my development PC, with local server, everything is OK.

On a test server with IIS and Excel, my program gets an error on the first
statement related to Excel :
Dim ApplicationExcel As New Excel.Application

Error message: Retrieving the COM class factory for component with CLSID
{...} failed due to the following error : 80070005.
Explanations : ASP.NET is not authorized to access the requested resource.
Etc.

What access rights should I grant to what resources ?

You should post to an ASP.Net NG, but what I suspect is that the Aspnet
worker process, which is used by all ASP.NET solutions, it has a machine
user account and it doesn't have the permissions.

 

[Gilbert Tordeur]

Thank you Paul. I suppose like you, but I do not know what permissions I
have to grant to ASP.NET
Gilbert