Error while connecting to the reporting server. Ensure that Virtual Machine Manager management pack and its reports are installed on the Operations Manager server. ID: 3451

You will encounter this error message when configure reporting for Virtual Machine Manager (VMM)
Error message:-

Error while connecting to the reporting server. Ensure that Virtual Machine Manager management pack and its reports are installed on the Operations Manager server. ID: 3451

Strange ! VMM 2008 R2 MP is by default available when you run "Configure Operation Manager". Why the system is asking again? Weird but here is the workaround that i use to solve this issue.

Workaround:-

Step 1:-Configure setspn and set special permission for SDK Account.

a) Logon to a domain controller within the domain with Domain admin rights

b) Use Command prompt and run the following command

Setspn.exe –A MSOMSDK/ OMservername.FQDN domain\SDKAccount (this is the SDK service account name)
Setspn.exe –A MSOMSDK/ OMservername domain\SDKAccount

Note:- To verify, run setspn -L OMservername
b) Run ADSIEdit.msc as a domain admin.

c) Find the SDK account, right click, properties.

d) Select the Security tab, click Advanced.

e) Click Add. Type “SELF” in the object box. Click OK.

f) Select the Properties Tab.

g) Scroll down and check the “Allow” box for “Read servicePrincipalName” and “Write servicePrincipalName”

h) Click OK three times.

i) Restart your SDK service – if AD has replicated from where you made the change – all should be resolved. The best is restart DC, VMM and Operation Manager.

Step 2 : Check Reporting URL (if still not available)
 
a) The Reporting URL must match between VMM and Operation Manager. To verify, on the Operation Manager Console, go to Administration > Settings > Reporting.

b)You will get your Reporting URL. Enter the same URL in the VMM console. Then, try use browser and access the Reporting URL. Verify that you can access the reporting and "System Center Virtualization Report 2008 R2" is available.

Step 3:- Verify System Center Virtualization Report 2008 R2 Report
a) On Operation Manager Console, Click on Reporting pane, do you see System Center Virtualization Report 2008 R2? Inside this report, consist of 5 reports for Virtualization.

b)If you did not see "System Center Virtualization Report 2008 R2", i advise that you perform uninstall of VMM console on the Operation Manager server. Then rerun "Configure Operation Manager" (available on VMM CD). After finish the installation, wait for a while before the report start to populating. Just keep refresh until 5 reports show up.

That should solve the problem. :)