From the Microsoft Dynamics GP Blogs: Management Reporter Fail; Payables Imports; Restore in GP 2015; HTTPS web services

A selection of the latest insight from the Microsoft Dynamics GP blogs:

• You receive "Couldn't retrieve the list of available databases: The connection attempt failed" error when updating Management Reporter 2012
• Using the Dynamics GP PM00400 table for Payables Imports
• Restore Issue on GP 2015 Drove Me Nuts!
• Web Services: Steps to change Web Services address from http to https in Microsoft Dynamics GP 2010 and later

You receive "Couldn't retrieve the list of available databases: The connection attempt failed" error when updating Management Reporter 2012

The Dynamics GP Blogster, better known as MVP Mariano Gomez, EVP of Midmarket Solutions at Intelligent Partnerships LCC, said he was at the very end of upgrading a client to Microsoft Dynamics GP 2015 R2, when he ran into an interesting issue when he was trying to update Management Reporter 2012 CU6 to CU9.

Here's the back story: Gomez said to create his client's test environment for the upgrade, his team cloned their production VMware environment and went through all the usual server renames, static IP changes, SQL Server renaming, etc.

"For the Management Reporter 2012 database server, we followed the applicable entries outlined in 'How to move Microsoft Management Reporter 2012' to a new server and in particular we removed the Application and Process services then ran the T-SQL script to re-create the certificate and symmetric key."

Then once ...