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?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

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 *