Avatar of ScottParker
ScottParkerFlag for United States of America

asked on 

ASP.net Web Server and Excel Issue

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?
ASP.NETMicrosoft IIS Web ServerWindows Server 2008

Avatar of undefined
Last Comment
ScottParker
Avatar of Alfred A.
Alfred A.
Flag of Australia image

Avatar of ScottParker
ScottParker
Flag of United States of America image

ASKER

I have reviewed those links and they are no help.
Avatar of ScottParker
ScottParker
Flag of United States of America image

ASKER

I added a line of code to both the Old server, and the New server.
 lblUserName.Text = System.Security.Principal.WindowsIdentity.GetCurrent().Name

On the old server,  the returned value is NT AUTHORITY\NETWORK SERVICE  
On the new server, the returned value is mylocaldomain/myusername
ASKER CERTIFIED SOLUTION
Avatar of ScottParker
ScottParker
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of ScottParker
ScottParker
Flag of United States of America image

ASKER

I got the solution in that other post.
ASP.NET
ASP.NET

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

128K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo