ASP.net Web Server and Excel Issue

ScottParker
ScottParker used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
I have reviewed those links and they are no help.

Author

Commented:
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

Author

Commented:
I got the solution in that other post.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial