Error when taking excel report

Question

Hi experts,

 

My ASP.net application uses excel to create reports.it works fine in the development system.But when i publish it in server the code throws exception

 

"

Retrieving the COM class factory for component with CLSID

{00024500-0000-0000-C000-000000000046} failed due to the following

error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005

(E_ACCESSDENIED

"

I uses the following code to create excel application

ExcelApp.Application myExcel = new ExcelApp.Application();

 

My server is windows 2008 and IIS7.

I had given permission to Microsoft excel application' in DCOMCNFG when i did some searching.but it didnt solve my issue.

Excel reports were worked fine before.i dont know what made wrong in the server.The server password changed recently.is there any issue related to this?.

How to solve the issue.pls help me..

 

Thanks in advance