SCCM 2007 SP1 Reporting Point error

Brian,

This 'should' fix it for you.


Simon

The real world is not about exam scores, it's about ability.

Nope - added Everyone with Read & Execute to the file mentioned (msvbvm60.dll), then rebooted the server - still gave the same error.

Can you tell me what OS you're running SCCM on?



Simon

The real world is not about exam scores, it's about ability.

The OS is Server 2003 R2 SP2. We have MSSQL 2005 SP1 installed on this server just for SCCM.

Any reason you don't have either SQL SP2 or SP3 installed? I was sure that SP2 was the minimum level of SQL SP required for SCCM SP1 but I could be wrong.

Simon

The real world is not about exam scores, it's about ability.

My mistake - it is SP2.

OK, it might be worth having a look into this as a possible fix, it's more aimed at SMS but could also fix your issue.

1 Log on to the Windows Server 2003 computer that is acting as the site server by using an account that has administrative permissions.

2 Click Start, click Run, type dcomcnfg, and then click OK.

3 In the Component Services MMC snap-in, expand Component Services, expand Computers, right-click My Computer, and then click Properties.

4 In the My Computer Properties dialog box, click the COM Security tab.

5 Under Launch and Activation permissions, click Edit Limits.

6 In the Launch Permission dialog box, make sure that the Everyone group has Remote Launch and Remote Activation permissions.

7 In the Component Services MMC snap-in, expand My Computer, expand DCOM Config, right-click SMS_Reporting_Point, and then click Properties.

8 In the SMS_Reporting_Point Properties dialog box, click the Security tab. Under Launch and Activation Permissions, select Customize, and then click Edit.

9 In the Launch Permission dialog box, make sure that the SMS Reporting Users local group has following permissions:
Local Launch
Remote Launch
Local Activation
Remote Activation

Give that a try and see if it resolves it.

Simon

The real world is not about exam scores, it's about ability.

Simon,

I tried this - I gave Everyone Remote Launch and Remote Activation rights in My Computer. The SMS Reporting Users group already had the needed rights. It didn't fix the error problem. But - I added the non-Domain Admin users to the SMS Reporting Users group - that fixed it. Now my problem is the reports pane on the left side of the window is blank for users in Domain Admins - but they appear for non-domain admin users. I tried adding the Domain Admins group to the SMS Reporting Users group, but that didn't resolve it. So the main problem is gone - just a small one to now figure out. I'll keep pegging away on this next week (I'm not here Monday, so don't expect any updates then!) - any ideas on this?

Brian

Any more ideas for me to try?

This has got me stumped.

If you have the Report Class set up for the SMS Reporting Users group correctly then I can't see why it would fail to display correctly, unless you have something like IE Enhanced Security applied for Admins but even then its more likely to give you a different type of error (prompting for login\password when you launch the reports etc).

I would check on the SCCM server just to see what the IE ESC settings are and remove them for Admins as well as users and give that a try.

Simon

The real world is not about exam scores, it's about ability.