SMS 2003 Report - Access Denied / ASP 0178 : 80070005

If you have got a SMS 2003 Server which runs on Windows Server 2003 with SP1 installed and if you gave access rights to a non-administrator user for SMS Reports , probably you are getting Error : Access is Denied error on IE. If you have already added this user to SMS Reporting Users local group on the SMS Server and if you are getting the error below

Server object error 'ASP 0178 : 80070005'
Server.CreateObject Access Error
/SMSReporting.SiteCode/Report.asp, line 64
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
The reason is hardened DCOM settings in Windows 2003 SP1

To resolve this problem run Component Services which is under Administrative Tools and find the SMS_REPORTING_POINT as shown below



Now select Security tab



Select Customize option for Launch and Activation Permissions then select Edit




Now add SMS_Reporting_Users local group and clear Local Launch option and select Allow for Local Activation, then aprrove all setting by click OK.

If you want to read more information about DCOM changes in Windows 2003 SP1 I recommend you to visit DCOM Security Enhancements site.