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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SQL Server 2017 ok for GP 2016?

(0) ShareShare
ReportReport
Posted on by 420

... or is that a little too far out on the bleeding edge? 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ibrahim Ghalghay Profile Picture
    115 on at
    RE: SQL Server 2017 ok for GP 2016?

    Dear BrainMan;

    Dynamics GP 2016 will most likely install with SQL 2017 fine, but when you launch GP 2016 Utilities to complete the installation, or to apply a hot fix, service pack, year-end update, etc., Utilities will fail on the SQL version check and won't allow you to proceed, and this is what makes SQL 2017 incompatible or not supported with Dynamics GP 2016.

    So it is possible to run GP 2016 on SQL Server 2017 if you migrate the databases.

    but since GP Utilities does an SQL version check (which is only necessary to prevent running older SQL Server versions, not newer ones!!!), an SQL version error message will appear and Utilities won't run... so you can not setup new companies, or apply a hot fix, service pack, year-end update... until you "downgrade" the SQL Server.

    Best Regards;

    Ibrahim

    please verify my reply as an answer if it helped you.

  • Verified answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at
    RE: SQL Server 2017 ok for GP 2016?

    Ibrahim is right.

    I wouldn't bet my Production systems on an unsupported SQL platform..

    Read on about the details here:

    community.dynamics.com/.../259775

  • Suggested answer
    Kirk Alexander Profile Picture
    420 on at
    RE: SQL Server 2017 ok for GP 2016?

    Thank you for your reply...

  • Suggested answer
    Kirk Alexander Profile Picture
    420 on at
    RE: SQL Server 2017 ok for GP 2016?

    Thank you for your reply, and your contributions on your linked post.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans