Wednesday 20 November 2013

IIS Error- 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)).


For this fallow the fallowing steps-

 Enable the ASP.NET authentication for default website (in IIS) then create Desktop folder at C:\Windows\System32\config\systemprofile\Desktop.

step1 :  Go to run type dcomcnfg 
Step2:   Click >Component services >Computes >My Computer>Dcom config> and select microsoft Excel Application> 
Step3:   Right Click on Microsoft Excel Application>Properties>Security Tab
Step4-Under-Launch and activation permission->Customise->Edit->Add--type-(IIS_IUSRS) 
-> ok -> Allow Permission-Local Lounch and Local Activation
Step5- Repeate Step4 for Under Access Permission

Reference--http://www.youtube.com/watch?v=ijfb3E_7t3o

No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...