Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Upgrade/Purchase SQL 2008 to SQL 2014

Posted on by 5

Hoping someone can help. The last time we upgraded Dynamics to GP 2010, Microsoft provided us with a disc for SQL Server 2008. Now that we need to upgrade to GP 2015, SQl Server 2014 is a requirement.

1) Do we purchase SQL server 2014 from Microsoft?

2) Does Microsoft provide one as we are on a service plan?

3) Our registered modules show SQL server 2012 however we never received a copy..

Can someone provide some direction? Appreciate the help

Thanks

*This post is locked for comments

  • GP_USER Profile Picture
    GP_USER 5 on at
    RE: Upgrade/Purchase SQL 2008 to SQL 2014

    Thanks Beat. The scramble is definitely on. Extended support for GP 10 is till October 2017

    blogs.msdn.microsoft.com/.../microsoft-dynamics-gp-10-0-mainstream-support-ending-on-october-9th-2012

  • 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: Upgrade/Purchase SQL 2008 to SQL 2014

    I see that you're currently running on GP 10.0..

    be careful about your upgrade path in case that's what you're looking for.. This version is not supported by Microsoft anymore and you'd have to go at least up to 2013R2 to be on valid support..

    For 2013R2, SQL 2014 is the last supported version.. (but you can also use SQL 2012).

    mbs.microsoft.com/.../MDGP2013_System_Requirements

    There are quite a few threads on this forum about the upgrade path:

    community.dynamics.com/.../157899

    just do a quick search

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Upgrade/Purchase SQL 2008 to SQL 2014

    Support tickets with Microsoft now cost $499 so I would not spend the money. Are you current on maintenance? If you are, you are entitled to SQL Server 2016 Standard Runtime. Send me a private message and we can discuss options.

  • GP_USER Profile Picture
    GP_USER 5 on at
    RE: Upgrade/Purchase SQL 2008 to SQL 2014

    In the company profile -- registered modules it shows SQL Server 2012 standard Edition

  • GP_USER Profile Picture
    GP_USER 5 on at
    RE: Upgrade/Purchase SQL 2008 to SQL 2014

    Thanks for the link. Unfortunately we have not had a partner for years. It is a small company with 4 users and I have done the upgrades over the years. Should I open a support ticket with Microsoft?

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Upgrade/Purchase SQL 2008 to SQL 2014

    If your GP license includes SQL Runtime then you can have your reseller login to PartnerSource and download the runtime version.

    https://mbs.microsoft.com/partnersource/northamerica/support/support-news/SQLServer2014_STD_ReleaseDownload

    Normally for our clients we log into PartnerSource from their server and download the desired version of SQL. Microsoft has not provided physical media in years. If you do not have SQL on your license you can certainly add it.

  • Verified answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: Upgrade/Purchase SQL 2008 to SQL 2014

    What edition of SQL 2008 are you currently running? Where is the reference to SQL Server 2012?

    I think there is a runtime edition of SQL 2014 which I believe doesn't require a separate license purchase.

    Regards,

    Kirk

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans