Excel -COM Class factory initialization error
-
We are exporting some data to excel and we have installed Excel 2007 in our Development/Staging/Production(Web Farm) environments. All the environments are running in Win 2003 Server,IIS 6. We are receiving the following error while initializing excel object in production. Application: System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType) at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(Type objectType) at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(Type serverType) at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(Type serverType, Object[] props, Boolean bNewObj) Event Log: The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID {00024500-0000-0000-C000-000000000046} to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool. We have given the permissions for Network Service in DCOMCNFG for Excel Application. The error is coming only in production and not in any other environments. I searched for solutions and all are pointing to giving Activation Permissions to Network Service(The application pool is running under this identity only) which has been done. I could not figure out any other reasons that may be causing this problem. Please help K.P.Kannan