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


Problem:

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.

 

Resolution:

  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 Support@Crestwood.com.


Share this:
 
 

Comments:

Add your comment:






Start a Support Ticket

Georgia
Director of Support

We'll get back to you
within 3 hours

Available
Monday-Friday
8am-5pm CST

support@crestwood.com | 847-394-8820 ext 7

2015 Support Team Stats

3845

support tickets
answered

74%

tickets solved
same day

92%

closed within
5 business days

Webinars & Events

Dec

6

Dynamics GP 2017 Year-end Training - Madison, WI

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

Dec

14

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

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

Dec

14

Dynamics GP 2017 Year-end Training - Maitland, FL

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