SMS 2003 SP1 and SP2 Reports Viewing Issues

After installation of SP1 and SP2 on the SMS 2003 server you may get the following error while using Web Reports:

Server object error 'ASP 0178 : 80070005'

Server.CreateObject Access Error

/SmsReporting_CS0/ReportsNav.asp, line 1055

The call to Server.CreateObject failed while checking permissions. Access is denied to this object.

Only Administrators won't get this error, unlike for every other user which has permissions for accessing SMS Reports.

So if you upgraded your reporting point to Windows Server 2003 SP1 or 2, you must reset the COM permissions so that the SMS Reporting Users Group has Local Launch permissions as it did prior to SP1 or SP2, as shown in the following procedure.

To grant Local Launch permission to the SMS Reporting Users Group:

*On the site system, from the Start menu, click Run and type Dcomcnfg.exe.

*In Component Services, click Console root, click Component Services, click Computers, click My Computer, click DCOM Config, and then click SMS_REPORTING_POINT. On the Action menu, click Properties.

*In the SMS Reporting Point Properties dialog box, on the Security tab, in the Launch and Activation Permissions section, click Edit.

*In the Launch and Activation Permissions dialog box, select the check box to allow Local Activation for SMS Reporting Users Group.

Note: Some administrators reported problems that they can't find "Reporting Users" local group..

For some reason "check names" option is not working there, you have to put full name of the group instead.