We help IT Professionals succeed at work.
Get Started

ASP.net Web Server and Excel Issue

264 Views
Last Modified: 2012-05-11
I am moving some internal web applications from 1 server to another.
The new server is Windows Server 2008 SP2  (32 bit)
It has Office 2003 installed on it.

When the web script tries to create an instance of Excel, it prompts the user to log in to the local machine.
If I cancel the log in, I get the following error message…
“Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.”

I have done the steps to add the user to the DCOM config.
1. Control Panel -> Administrative Tools -> Component Services
2. Console Root -> Component Services -> Computers -> My Computer -> DCOM Config
3. Right-Click 'Microsoft Excel Application' and choose Properties
4. Click 'Security' tab
5. Customize 'Launch and Activation Permissions'
6. Add the local ASPNET user and give it all permissions .. Also added “NETWORK SERVICE”
7. Reboot

With still no luck…
Any other ideas?
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE