Upgrade .Net IIS server from Windows 2003 to Windows 2008 caused applications with Excel upload failed.

We upgraded  .Net IIS server from Windows 2003 to Windows 2008.
After upgrade
1) those applications that has function to upload from Excel failed.  
2) some links intermittently work / failed. Sample Error as below:

Error (LoadLayer): System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005.
   at RMS.ReadExcel.getExcelScannerJobFile()
   at RMS.SJF.LoadLayer()



Please help if you have any idea  to solve this. Thank you.
Panda 5888EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mwenenkoCommented:
Start run DCOMCNFG,
Right click on the My Computer -> properties.
Click on COM Securities tab

In Access Permissions, click "Edit Defaults" and add Network Service to it and give it "Allow local access" permission. Do the same for <Machine_name>\Users.

In launch and Activation Permissions, click "Edit Defaults" and add Network Service to it and give it "Local launch" and "Local Activation" permission. Do the same for <Machine_name>\Users
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Panda 5888EngineerAuthor Commented:
Hi Expert,

Done as proposed
Start run DCOMCNFG,
 Right click on the My Computer -> properties.
 Click on COM Securities tab

 In Access Permissions, click "Edit Defaults" and add Network Service to it and give it "Allow local access" permission. Do the same for <Machine_name>\Users.

 In launch and Activation Permissions, click "Edit Defaults" and add Network Service to it and give it "Local launch" and "Local Activation" permission. Do the same for <Machine_name>\Users

and rerun again the application.
HIt the same error

error message 1:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Exception Summary
-------------------------------
5/21/2015 : 4:08 PM
-------------------------------
System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005.
   at FW.ReadExcel.getExcelProcessSpec(String specFilePath)
   at FW.extract.ExtractXlsToDB(String uniqKey, String attSpecName)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
error message 2:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Error(Load Steps to FWEXCEL_PROCESSSTEP): System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005.
   at FW.ReadExcel.getExcelProcessSpec(String specFilePath)
   at FW.extract.ExtractXlsToDB(String uniqKey, String attSpecName)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Please help
0
Rainer JeschorCommented:
Hi,
WIndows Server 2008 is 64bit only - therefore all IIS sites / applications run in 64bit mode by default.
Have you set your IIS application to run in 32 bit mode?
HTH
Rainer
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Panda 5888EngineerAuthor Commented:
Hi,
Meaning that originally all the 32 bit programs was not able to run in WIn 2008?
Please advise
0
Panda 5888EngineerAuthor Commented:
Hi,
May I ask if any way to run 32 bit programs in 64 bit env with minimal recoding ?
0
Panda 5888EngineerAuthor Commented:
May I ask what is Desktop Heap Memory ?
0
Panda 5888EngineerAuthor Commented:
No comment
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.