Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

SQL Server 2017 ok for GP 2016?

Posted on by 410

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

*This post is locked for comments

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

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

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

    Thank you for your reply...

  • Verified answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 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

  • Verified answer
    Ibrahim Ghalghay Profile Picture
    Ibrahim Ghalghay 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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans