Support for Microsoft Dynamics, Acumatica, and Greentree

« Back to Search

Management Reporter Configuration Console Stopped Working

Posted by Brandon Richards, Implementation Manager on October 18, 2017


I ran into a unique issue today.  A client had reset their SA password, and after doing so, they could no longer login to Dynamics GP or SQL with the SA password.  The SQL SA account kept getting locked out.

We determined this was being caused by the Management Reporter (MR) services.  When trying to launch the MR Configuration Console to fix the password issue, the console kept crashing with this error: “The Configuration Console has stopped working.”  MR had been configured to use the Dynamics GP Legacy connection rather than the datamart using SQL authentication.



  1. First, connect to SQL Server Management Studio using Active Directory authentication
  2. Reset the SA  login back to what it previously was and unlock the account
  3. Launch the MR Configuration Console 
  4. Remove the Process and Application services within MR
  5. Once both those processes are removed, return to SQL Server Management Studio and reset the SA login to your new password. 
  6. Last, go back to the MR Configuration Console and re-add the Process and Application Services using either the new “SA” login and password, or Windows Authentication, making sure the AD user has the proper access to the MR database in SQL.


Once this was completed, the sa password was updated to the new password and we were no longer getting locked out.  MR was also working correctly and we could get into the configuration console without it crashing.


If you need assistance, email our team of Dynamics and MR experts at

Share this:


Add your comment:

Start a Support Ticket

Director of Support

We'll get back to you
within 3 hours

8am-5pm CST | 847-394-8820 ext 7

2015 Support Team Stats


support tickets


tickets solved
same day


closed within
5 business days

Webinars & Events



Dynamics GP 2017 Year-end Training - Madison, WI

Wednesday, December 6, 2017  |  9:00 AM–3:00 PM  |  Free



Dynamics GP 2017 Year-end Training - Farmington Hills, MI

Thursday, December 14, 2017  |  1:00 PM–4:00 PM  |  Free



Dynamics GP 2017 Year-end Training - Maitland, FL

Thursday, December 14, 2017  |  1:00 PM–4:00 PM  |  Free