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 does NOT work with SQL 2017

Management Reporter 2012 is currently not compatible with Microsoft SQL Server 2017. Hopefully Microsoft will get around to releasing a patch to fix this. While trying to configure the Application Service, this error message popped up:   Here’s what the deployment log showed: The database deployment failed. Additional information: Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package. —> … 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