Management Reporter

Management Reporter Error - Can't connect to the Management Reporter server. Do you want to specify a different server address?

This happens when the Management Reporter Server is down.

You have to go to Control Panel-->Administrative Tools-->Services

Start the following below mentioned services

Management Reporter Process Service
Management Reporter 2012 Application service

------------------------------------------------------------------------------------------------------------------------

Query to Clear Management Reporter Queue

USE ManagementReporter

Select * FROM [ManagementReporter].[Reporting].[Repository] WHERE StatusType<> '0'

Begin Tran

Delete FROM [ManagementReporter].[Reporting].[Repository] WHERE StatusType<> '0'

Rollback Tran