Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue

It’s always the small things which catch you out.

The recent test upgrade for a client I did between Microsoft Dynamics GP 10 SP5 and Microsoft Dynamics GP 2010 R2 hit a minor snag during the GP Utilities section of the upgrade which resulted in this error message;

As soon as I saw the error message I realised the ommission I had made when transferring the SQL database onto the new SQL Server. When moving a database between SQL Server 2000 and SQL Server 2008 the compatibility level of the database needs to be changed.

This is done via SQL Server Management Studio. Right click on the database (this needs to be done on the system database and all of the company databases) and click Properties;

Select Options and change the Compatibility Level from SQL Server 2000 (80) to SQL Server 2008 (100);

Restart GP Utilities and restart the upgrade process.