Dynamics GP SSRS deployment NOT supported on SQL Express

So, it turns out that Deploying Reports from Dynamics GP to SQL Server Reporting Services (SSRS) is NOT supported on SQL Express. This deployment only works with SQL Server 2012, 2014, 2016 Standard or Enterprise Editions. Note, SSRS still works with SQL Express, but you’ll need to manually create the all the reports. We haven’t … Read more

Management Reporter 2012 needs patch for SQL 2017

Update¬†— Management Reporter CU16 v2 has added support for SQL 2017. You can find out more about the updated CU16 release here: https://blogs.msdn.microsoft.com/dynamics_financial_reporting/2018/03/20/updated-management-reporter-cu16-now-available/ You can download the updated build of CU16¬†here. —- original article below: Management Reporter 2012 does NOT work with SQL 2017 Management Reporter 2012 is currently not compatible with Microsoft SQL Server … Read more

Dynamics GP upgrade fails – SQL server was renamed

If the computer holding your Dynamics GP SQL databases is renamed, this can lead to a number of problems including failed Dynamics GP upgrades. Internally, SQL server still thinks it’s name is ‘old-server-name’ instead of it’s new name of ‘new-server-name’ – this causes the upgrade to fail. Whenever a virtual SQL server is created from … Read more