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?
http://support.microsoft.com/kb/257757
http://social.msdn.microsoft.com/Forums/en-US/innovateonoffice/thread/b81a3c4e-62db-488b-af06-44421818ef91?prof=required