Excel interop permissions issue?

VB .NET 2005 (ASP.NET); Excel Interop 11 (Excel 2003); Windows 2003

I've got an app that needs to use the Excel Interop to generate a spreadsheet. This works great on my machine. :)

When I put the page on the server, I get a COM access exception. When I look in the registry, the COM id matches the Excel interop id in the DCOM tree in Component Services. Through Component Services, I have given both the ASPNET user and the guest internet use full permissions to the DCOM object. I've also done the same through explorer for Excel.exe.

The stack trace is:
[UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.]
   ExcelHelper.FormatWorksheet(String fileName, String lineNumber, Int32 rowCount) +35
   ExcelHelper.GenerateWorkDocument(String templateName, String fileName, Int32 lineId) +221
   Secure_ViewWorkTickets.Page_Load(Object sender, EventArgs e) +97
   System.Web.UI.Control.OnLoad(EventArgs e) +98
   System.Web.UI.Control.LoadRecursive() +71
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4310

Any suggestions as to what I might be doing wrong?Start Free Trial