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 missing DSN – 32 bit vs 64 bit ODBC / DSN

If you’re reading this article, you’ve probably just installed Dynamics GP (32 bit program) on a 64 bit computer. These days most new PCs & servers use 64 bits instead of the older 32 bit standard. To maintain compatibility, a 64 bit version of Windows has both 32 bit and 64 bit versions of the … Read more

SQL log files fill hard drive: how to fix. Dynamics GP Support

If you have a SQL server with a full hard drive there’s a pretty good chance that the drive was filled with SQL log files (.ldf files). You have to backup the Transaction logs before you can shrink the log file; the problem is that from SQL Management Studio you can typically only backup to … 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