Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue

Microsoft Dynamics GPIt’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;

Microsoft Dynamics GP 10 Utilities

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;

Microsoft Dynamics GP 10 Utilities

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

Company Setup

Restart GP Utilities and restart the upgrade process.

What should we write about next?

Your Name (required) -
Your Email (required) -

1 thought on “Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue

Leave a Reply

Your email address will not be published. Required fields are marked *