Users working on upgrading Dynamics GP from GP 2010 to GP 2016 who have successfully installed Dynamics GP 2016 R2 and SQL Server 2016 have been getting the following error message when trying to install Management Reporter 2012 with Cumulative Update 15:

“Couldn’t retrieve the list of available databases: the connection attempt failed.”

What causes this error

After coming across this error message during a Dynamics GP 2016 upgrade, it seemed to only happen if Dynamics GP 2016 is already installed on the server. The error comes about due to Dexterity Shared Components. When Dynamics GP 2016 is installed, the program installs Dexterity Shared Components Version 16. However, Management Reporter 2012 works with a lower version of Dexterity Shared Components. If Dynamics GP 2016 is already installed, Management Reporter does not install the required Dexterity Shared Components version due to the presence of the version installed by Dynamics GP 2016.

How to solve this error when installing Management Reporter

Close the Management Reporter Configuration Console and manually install the Dynamics GP 2013 Dexterity Shared Components version 12.

Go to: MDGP2013_R2_DVD_ENUS\MDGP2013_R2_ENUS\Tools\Dex

After the correct version of Dexterity Shared Components is installed, users will be able to proceed with management reporter configuration with no error.

Microsoft Dynamics GP support provided by Citrin Cooperman

Citrin Cooperman’s Digital Services Practice can help your business get the most out of its Microsoft Dynamics GP investment and troubleshoot issues you may encounter to can save time, money, and frustration.

To learn more about how our team can assist with Dynamics GP upgrades and support, reach out to your Citrin Cooperman advisor or sales@citrincooperman.com.

Need to make the move from Dynamics GP?

As a Dynamics GP user, it is important that you understand GP End of Life. It is not just a distant event; it carries substantial implications that every business must be aware of. To learn more, please watch our on-demand webinar, Microsoft Dynamics GP End of Life – What’s Next, to:

• Gain a firm grasp of the critical dates that will shape your decision-making process;
• Decode the terminology to understand how it will directly affect your day-to-day operations and the future of your organization; and
• Delve into the security and business continuity risks that may jeopardize your organization.

Click here to watch now.