web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / MS Great Plains 2013 R2
Finance | Project Operations, Human Resources, ...
Suggested Answer

MS Great Plains 2013 R2

(0) ShareShare
ReportReport
Posted on by eric.harvilicz 5

Does any one know what is the latest version of SQL Server I could use for a MS Great Plains 2013 R2?  I wanted to try and make it work with SQL Server 2019 (using compatibility mode of course), but it looks like the initial launch of GP does not like the newer database version.  Thoughts?  

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    Here are the system requirements for GP 2013.SQL 2019 is not an option.

    https://www.encorebusiness.com/app/uploads/2013/05/2013-System-Requirements.pdf

    MicrosoftSQLServer2012‐Standard

    or

    ExpressEditionsMicrosoftSQLServer2008R2SP1

    or later

    Standard,WorkgrouporExpressEditions

    MicrosoftSQLServer2008SP3

    or later

    Standard,WorkgrouporExpressEdition

  • Suggested answer
    Terry R Heley Profile Picture
    Terry R Heley Microsoft Employee on at

    Hi Eric, here is a cheat sheet I have, similar to what Richard posted 2019 will not work on GP 2013 sorry :-)

    GP 2013 supports

    SQL 2014, 2012, 2008

    GP 2015 supports

    SQL 2014, 2012

    GP 2016 supports

    SQL 2016, 2014, 2012

    GP 2018 supports

    2017, 2016 and 2014

    GP 18.2/18.3 supports

    SQL 2019 plus 2017, 2016 and 2014

    David Musgrave wrote a blog on a dex.ini switch you can look at

    winthropdc.wordpress.com/.../

    Thanks

    Terry Heley

    Microsoft

  • Suggested answer
    Justin Sutton Profile Picture
    Justin Sutton on at

    Hi Eric, 

    Richard is spot on. There is no supported way to get GP 2013 to work on SQL Server 2019. 

    In fact, SQL Server 2019 and GP 2013 do not have any Server Operating systems in common either. 

    Is there a reason you are wanting to use such an old version of GP? There may be a better way to reach your goals. 

    Thanks!

  • eric.harvilicz Profile Picture
    eric.harvilicz 5 on at

    Justin,

    We are actually just keeping this around as a legacy application.  No biggie, I can install SQL Server 2008.  Thank you both for you help!

  • eric.harvilicz Profile Picture
    eric.harvilicz 5 on at

    Ok.  So now I'm just trying to have a new install point back to the SQL Server 2008 sql server and it won't launch.  I see this in the log file:

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 309 does not support upgrading from version 8.0.0.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 346 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 414 does not support upgrading from version 10.0.1071.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 1045 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 1428 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 2150 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 3180 does not support upgrading from version 9.0.30.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 3258 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 3830 does not support upgrading from version 10.0.67.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 4067 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 4421 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 309 does not support upgrading from version 8.0.0.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 346 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 414 does not support upgrading from version 10.0.1071.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 1045 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 1428 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:29 PM.  Error:  Product 2150 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 3258 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 3830 does not support upgrading from version 10.0.67.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 4067 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 4421 does not support upgrading from version 10.0.1061.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 309 does not support upgrading from version 8.0.0.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 346 does not support upgrading from version 8.0.0.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 414 does not support upgrading from version 8.0.0.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 1045 does not support upgrading from version 8.0.0.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 1428 does not support upgrading from version 8.0.0.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 2150 does not support upgrading from version 9.0.14.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 3258 does not support upgrading from version 8.0.0.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 4067 does not support upgrading from version 9.0.18.

    Failure encountered ON 12/12/2020 at 1:54:30 PM.  Error:  Product 4421 does not support upgrading from version 8.0.0.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    You have a mixture of version 8, 9 and 10 products in your database. I would start by doing an internet search on GP product IDs and then you can strip them out of your DYNAMICS.SET file.

    You can start with this to help get you to a good starting point.

    https://community.dynamics.com/gp/b/dynamicsgp/posts/upgrade-paths-to-microsoft-dynamics-gp-2013

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at

    Along with all that has been said, you can also run into these type of version errors if a product/feature was installed at a early version (i.e. 8.0, 10.0) and then not installed/upgraded through your current version of Dynamics GP.

    Then, you decide you want to install these features again, and Utilities sees version information in the databases where there isn't a direct upgrade path, i.e. you can't go from 8.0 to GP 2013 directly, and would need to be on a specific version/build of GP 10.0 to go directly to GP 2013.

    In the cases where there isn't any upgrade path, you can use the information in this blog, to re-initialize the features you need, which will cause GP Utilities to re-install the feature new at your current version, opposed to trying to upgrade it, thus resolving the version errors:

    community.dynamics.com/.../quot-problem-ascertaining-version-information-quot-error-when-installing-or-upgrading-microsoft-dynamics-gp

    Thanks

  • eric.harvilicz Profile Picture
    eric.harvilicz 5 on at

    Ok.  This has turned into a pain.  Does anyone have any documentation on a straight migration of GP 2013 to new servers?  

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at

    If you're meaning migrating the databases:

    KB 878449 - How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server

    support.microsoft.com/.../how-to-transfer-an-existing-microsoft-dynamics-gp-microsoft-small-busi

  • eric.harvilicz Profile Picture
    eric.harvilicz 5 on at

    Derek,

    Sorry, I should have been more clear. I'd like to move both the application and database server to new servers.

    Thanks,

    Eric

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans