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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP2015 and SQL 2017.
Microsoft Dynamics GP (Archived)

GP2015 and SQL 2017.

(0) ShareShare
ReportReport
Posted on by Hossam Fathy 2,611

Hi Microsoft,

Is there any way to use GP2015 with SQL 2017.

I have a customer using GP2013 and upgraded his SQL to 2017 and his GP2013 Build can only upgrading to GP2015, So i am stuck now.

Any Solution for this issue.

Thank you.

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    GP 2015 is compatible with SQL 2012 and 2014.

    GP 2016 is compatible with SQL 2012 and 2014 and 2016.

    GP 2018 is compatible with SQL 2014 and 2016 and 2017.

    So your only choice now is GP 2018. You should always check the system requirements before upgrading. You will need to upgrade to GP 2015 or 2016 and then to GP 2018 as there is no way to go directly to GP 2018.

    Here are the system requirements for GP 2018.

    https://mbs.microsoft.com/customersource/northamerica/GP/learning/documentation/system-requirements/MDGP2018_System_Requirements

    Here are the upgrade paths.

    http://www.terrcon.com/dynamics-gp-support/2018/01/dynamics-gp-2018-upgrade-paths/

  • Hossam Fathy Profile Picture
    Hossam Fathy 2,611 on at

    Hi Richard,

    I am on this situation now, The Customer IT upgraded to SQL 2017 without checking with me.

    so what is the solution now.

    as i mentioned my current GP Build Number not allow me to upgrade to GP2016 so i forced to upgrade to GP2015, and GP2015 not supported by SQL 2017.

    By the was GP2015 is working with SQL 2016, Microsoft must upgrade the system requirements document for all versions.

    Wish you can give me a solution.

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

    You only have two options.

    Option 1) Upgrade GP to 2018

    Option 2) Downgrade SQL to 2014

    Can you install SQL 2014 as a second SQL instance? When they installed SQL 2017 did they perform an actual upgrade or did they install SQL 2017 as a separate instance? I have seen this plenty of times before. IT staffs just start upgrading that which they know and the heck with everything else.

  • Lucas Miller Profile Picture
    Lucas Miller on at

    Hello,

    Dynamics GP itself will often work with unsupported/untested versions of SQL Server, but you will definitely be version checked when you try to run Dynamics GP Utilities to perform an upgrade or create a company and you won't be able to proceed.

    The SQL compatibility requirements that Richard mentioned are correct.

    Since you're on Dynamics GP 2013 you can only upgrade to GP 2015 or GP 2016.   Neither of those are compatible with SQL 2017, so you're only option is really to downgrade SQL to a compatible version.  That is a tricky process since the databases would have been upgraded as soon as you restored them to SQL 2017 and that means you cannot restore backups to an older version of SQL.  

    We have done SQL downgrades as a billable advisory services in the past so if you're interested you can open a support case to begin the process of getting a quote.  You could also check the Microsoft Pinpoint site to see if there are other partners who provide that service.

    Lucas Miller

    Microsoft Dynamics

  • Hossam Fathy Profile Picture
    Hossam Fathy 2,611 on at

    this is SQL upgrade

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

    Do you have backups prior to the upgrade of SQL? If you do the simplest thing to do would be to install a second instance of SQL that matches the previous version of SQL. Follow the steps in KB878449. This will get GP running  again.  If no backups are available your only choice is to upgrade to GP 2018. The problem here is you are going to need an instance of SQL 2014 running to make the hop to GP 2015 or GP 2016. Hopefully you are running images and can fire up up the images that are configured properly for the version of GP you are using. As Lucas mentioned the version checking that GP Utilities will perform dictates what is required. If possible, I would engage your GP reseller on this project. You have already experienced what happens when those with no GP experience start making changes.

  • Hossam Fathy Profile Picture
    Hossam Fathy 2,611 on at

    Hi Richard,

    Yes there is Full back but there is more than one month data so i can't just use old backup.

    what is your idea exactly?

    Thank you for your time and waiting your reply.

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

    When did the SQL upgrade occur? Have they entered data since the upgrade? How much data? They may be running right now but any future GP upgrades will not be possible. My thinking is to create an image back to the day before the SQL upgrade. Put SQL 2014 on this image. Restore all the databases and then they will need to re-enter all transactions. Once that is done you can upgrade to GP 2015 or GP 2016. You could finally move this data to the SQL 2017 image and upgrade to GP 2018. The longer they keep using the current installation the worse this becomes. It just means more transactions will need to be re-entered. There is no easy solution here. This is a mess. If you require assistance with this let me know. We do GP upgrades all the time and have images ready to upgrade any version of GP.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    If they already entered data in that SQL instance while running on SQL 2017, then it's too late to resort to the old backups.. they are useless at this point.

    The only option Microsoft is going to do, is bulk export all your data from GP 2015 in your SQL 2017 instance and re-import them into a lower SQL version (i.e 2014) to be able to perform your upgrade to a new version of GP.

    That's the only way to go when you have no current backup from an older SQL version.

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

    Good point Beat. I neglected to mention that. It all depends on how much data has been entered. There is no easy solution. Whoever did the SQL upgrade is responsible for this mess. The funds need to come out of their budget to correct this.

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

News and Announcements

Season of Giving Solutions is Here!

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 > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans