You’re working on upgrading Dynamics GP from GP 2010 to GP 2016, and have successfully installed Dynamics GP 2016 R2 and SQL Server 2016. You go to install Management Reporter 2012 CU 15, however, you get this error message:
“Couldn’t retrieve the list of available databases: the connection attempt failed.”
What do you do and what causes this error?
After coming across this error message during a Dynamics GP 2016 upgrade, I noticed this only happens 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 Report 2012 works with a lower version of Dexterity Shared Components. If Dynamics GP 2016 is already installed, Management report does not install the Dexterity Shared Components version is requires due to the presence of the version installed by Dynamics GP 2016.
To solve this issue, close 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, you will be able to proceed with management reporter configuration with no error. It really works! As always, let us know if you have any questions or feedback!
As a company who has worked with businesses throughout New York to help users make the most out of Dynamics GP, the MIBAR team is ready and able to help you on your move away from the platform—providing a secure, efficient, and seamless transition to a future-proof cloud product. Learn more about Dynamics GP alternatives.
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 & future of your org.
- Delve into the security & business continuity risks that may jeopardize your organization.
Click here to watch now.