Microsoft Dynamics GP, Microsoft Dynamics Retail Management Systems, Microsoft SQL Server version compatibilities
Posted on 2016-08-03
I need some assistance determining version compatibilities of our Microsoft Dynamics GP 9.0 with Microsoft Dynamics RMS Version 220.127.116.11 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 18.104.22.168 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: 22.214.171.124
Microsoft Dynamics GP Integration Manager 9.00.0029
Microsoft FRx version 6.7.5014
Our Microsoft Dynamics GP Profession version is 9.00.0274
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 2.63.04.05.06.0
Microsoft Internet Explorer 8.0.6001.18702
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.