Microsoft Dynamics GP, Microsoft Dynamics Retail Management Systems, Microsoft SQL Server version compatibilities

Posted on 2016-08-03
Last Modified: 2016-08-15
I need some assistance determining version compatibilities of our Microsoft Dynamics GP 9.0 with Microsoft Dynamics RMS Version and MS SQL Server 2012?  We have a vendor assisting on the RMS POS side but they are not too sure about the GP side of the integration.

Our current version of RMS is 2.0.0123.  We would like to upgrade to for RMS Store Operations, POS and Headquarters so we can use new EMV credit card terminals.  One of the requirements for the HQ upgrade is an upgrade to SQL version 2012. We need to learn if these upgrades with conflict with our GP version, Microsoft FRx reporting and the integration manager link between GP and RMS.  
Current Version of Microsoft Dynamics Retail Management Systems = 2.0.0123
Version after upgrade:

Microsoft Dynamics GP Integration Manager 9.00.0029

Microsoft FRx version 6.7.5014

Our Microsoft Dynamics GP Profession version is 9.00.0274
Dexterity 9.00.0068.0
Smartlist 9.00.0258
Database SQL Server
ODBC Driver Manager 03.52.0000
ODBC Driver 09.00.5000

Microsoft SQL Server 2005 – 9.00.2047.00(Intel x86)
Our Great Plains Server is a Windows Server 2003 RS Std Edition Service Pack 2

On that server the MS SQL Server install has the following version info:
Operating System 5.2.3790
Microsoft .NET Framework 2.0.50727.3662
Microsoft MSXML
Microsoft Internet Explorer 8.0.6001.18702
MDAC 2000.086.3959.00(srv03_sp2_rtm.070216-1710)
SQL Server Management Studio 9.00.5000.0

If we need to upgrade Great Plains to a higher version, please provide SQL version required and if that SQL version will work with the required RMS version.

Any assistance would be greatly appreciated.

FYI: Microsoft has announced the end of support for RMS with extended support ending in 2021 and Microsoft ended support of our version of GP five years ago.
Question by:wineybob18
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 30

Assisted Solution

pgm554 earned 250 total points
ID: 41741368
Going through the gp 9 upgrade now.
Better to just bite the bullet and upgrade to 2016 and SQL 2016.

In order to move to the latest sql from 9 ,there are 2 to 3 intermediate sql upgrades you need to perform.

And get rid of server 2003.
LVL 18

Accepted Solution

Victoria Yudin earned 250 total points
ID: 41744588
I just found GP 9.0 system requirements from 2007 - looks like the latest version of SQL compatible with it is SQL 2005. It's possible that SQL 2008 might be ok with a particular service pack, but I do not have any specific notes that I was able to find on this. Either way, you're between SP 1 and SP 2 based on your build (, so if you're staying on that build, SQL 2005 is it.

While it is possible that you GP will work on newer versions of SQL, you will cut yourself off from the ability to create new companies, apply services packs or perform upgrades in the future because at those steps the GP application will check the SQL version and determine that there is a problem and then prevent you from going further.

If you are current with your Dynamics GP maintenance, you can log into CustomerSource and find all the information you need on the currently supported versions of GP. Here is a list with support dates:

You can also find all the links needed for SQL compatibility, etc. on my blog:
GP 2016:
GP 2015:
GP 2013:

If you are not current on your Dynamics GP maintenance, I would recommend talking to your GP Partner first about your options and what it will cost to upgrade, as there can be some very stiff penalties for not having stayed current on maintenance.

Hope that helps.

Author Closing Comment

ID: 41756689
Thanks for your insights!

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question