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