Solved

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

Posted on 2016-08-03
3
128 Views
Last Modified: 2016-08-15
I need some assistance determining version compatibilities of our Microsoft Dynamics GP 9.0 with Microsoft Dynamics RMS Version 2.0.2.14 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 2.0.2.14 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: 2.0.2.14

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 2.63.04.05.06.0
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.
0
Comment
Question by:wineybob18
[X]
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
3 Comments
 
LVL 30

Assisted Solution

by:pgm554
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.
0
 
LVL 18

Accepted Solution

by:
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 (https://victoriayudin.com/2010/09/11/dynamics-gp-version-numbers-and-service-packs/), 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: https://victoriayudin.com/2008/10/08/when-does-my-gp-products-support-end/.

You can also find all the links needed for SQL compatibility, etc. on my blog:
GP 2016: https://victoriayudin.com/gp-2016-resources/
GP 2015: https://victoriayudin.com/resources/gp-2015-resources/
GP 2013: https://victoriayudin.com/resources/gp-2013-resources/

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.
0
 

Author Closing Comment

by:wineybob18
ID: 41756689
Thanks for your insights!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
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…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

738 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