Management Reporter Reports Stuck in Queue

ISSUE
After generating a report, the Report Queue Status window lists the Status as Queued rather than Processing and report never finishes.

CAUSES
There are five possible causes for this error as noted below along with the five corresponding fixes.

Cause 1: If the Management Reporter Process Service is on the same machine as the machine hosting your ManagementReporter SQL database. The Process Service may have errored out by attempting to start before SQL Server was accepting connections. See Fix 1 in the Fix section.

Cause 2: A SQL Server connection error has occurred and the Management Reporter Process Service needs to be restarted. See Fix 2 in the Fix section.

Cause 3: The user running the Management Reporter Process Service does not have sufficient permissions to read from the ManagementReporter SQL Server database. See Fix 3 in the Fix section.

Cause 4: The SQL Service Broker on the ManagementReporter SQL Server database is not enabled. See Fix 4 in the Fix section.

Cause 5: This can happen if the owner of the Management Reporter database is a Windows User while the SQL Server Service is being run by a local user. If you check the Event Viewer, you may see this message: An exception occurred while enqueueing a message in the target queue. Error 15404, State 19. Could not obtain information about Windows NT group/user ‘domainuser’, error code 0x5.

FIXES:
Fix 1: A) If using Windows Server 2008 you can set the Set Process Server Service to Automatic (Delayed Start) rather than Automatic. OR B) Restart Process Service manually or with a script similar to the following: NET STOP MRProcessService NET START MRProcessService

Fix 2: See Fix 1B above

Fix 3: Grant the user running this service the GeneralUser role under the Management Reporter database in SQL Server. This user can be found on the Log On tab under the Services Control panel.

Fix 4: Run the following statement on the SQL server where your ManagementReporter database resides: SELECT name, is_broker_enabled FROM sys.databases WHERE name = DB_NAME() AND is_broker_enabled = 1

This statement should return a row for the ManagementReporter SQL Server database. If it does not, run the statement below to re-enable the SQL Service Broker on the ManagementReporter SQL Server database:

ALTER DATABASE [ManagementReporter] SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

Fix 5: Change the database owner to sa or change the SQL Server Service user to a domain user.

Thanks to Derek Krebs at boards.msxgroup.com

Don't miss...