troubleshooting Question

ASP.net Web Server and Excel Issue

Avatar of ScottParker
ScottParkerFlag for United States of America asked on
ASP.NETMicrosoft IIS Web ServerWindows Server 2008
5 Comments1 Solution268 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
ScottParker

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros