Management Reporter: Clear Queue

To clear the queue of stuck reports in Management Reporter run the below in SQL server management studio.

USE MANAGEMENTREPORTER
DELETE RepositoryMessage

This will clear the queue.

Unable to complete login process due to delay in opening server connection

You may receive this error when trying to create a new odbc connection to the server for dynamics gp.

To resolve this error:
Go to the server and change the firewall settings. Disable the firewall for the Domain Profile.

Voila!