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 :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 2013 SP2 and SQL Se...
Microsoft Dynamics GP (Archived)

GP 2013 SP2 and SQL Server 2014

(0) ShareShare
ReportReport
Posted on by RussK 1,875

I have a 3rd party application I am incorporating into an upgrade from GP10.00.1868 to GP 2013R2 that requires me to 'stop-off' at GP 2013SP2. Unfortunately, I have GP 2013SP2 installed with GP10.00.1868 DBs on the SQL Server 2014 at the 100 compatibility level, I get a message that 'Your current SQL Server is not a supported version.' I have been looking for system requirements for GP 2013SP2, but all I find is requirements documents for GP 2013R2. I see in that document that SQL Server 2014 is supported, but the 'pre-requisite' is GP 2013R2. Is this the expected behavior? I guess I might as well dust off a VM and install SQL Server 2012 on it with GP 2013SP2, and be done with this...

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: GP 2013 SP2 and SQL Server 2014

    Here is the link.

    mbs.microsoft.com/.../mdgp2013_system_requirements

  • Community Member Profile Picture
    Community Member on at
    RE: GP 2013 SP2 and SQL Server 2014

    32-bit

    x64

    Database

    Requirements

    Microsoft SQL Server 2014

    - Standard or Express Editions

    (Prerequisite is Microsoft Dynamics GP 2013 R2)

    Microsoft SQL Server 2012

    - Standard or Express Editions

    Microsoft SQL Server 2008

    R2 SP1 or later - Standard,

    Workgroup or Express Editions

    Microsoft SQL Server 2008

    SP3 or later - Standard,

    Workgroup or Express Editions

    Supported Microsoft SQL

    Server Collation

    1. Dictionary Order Case

    Insensitive - Sort Order 52

    In the SQL Server

    Management Studio, right-

    click the SQL Server Name

    and click Properties: Server

    Collation = SQL_Latin1_General_CP1_CI_AS

    2. Binary - Sort Order 50

    In the SQL Server

    Management Studio, right

    -click the SQL Server Name

    and click Properties:

    Server Collation = Latin1_General_BIN

    Microsoft SQL Server 2014

    - Standard or Express Editions

    (Prerequisite is Microsoft Dynamics GP 2013 R2)

    Microsoft SQL Server 2012

    - Standard or Express Editions

    Microsoft SQL Server 2008

    R2 SP1 or later - Standard,

    Workgroup or Express Editions

    Microsoft SQL Server 2008

    SP3 or later - Standard,

    Workgroup or Express Editions

    Supported Microsoft SQL

    Server Collation

    1. Dictionary Order Case Insensitive - Sort Order 52

    In the SQL Server

    Management Studio, right

    -click the SQL Server Name

    and click Properties: Server

    Collation = SQL_Latin1_General_CP1_CI_AS

    2. Binary - Sort Order 50

    In the SQL Server

    Management Studio, right

    -click the SQL Server Name

    and click Properties: Server

    Collation = Latin1_General_BIN

  • Verified answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: GP 2013 SP2 and SQL Server 2014

    Russ,

    You might try changing the compatibility setting on the Database properties, prior to resorting to putting another VM into service.  Try 110, which is 2012.

  • Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: GP 2013 SP2 and SQL Server 2014

    Hi Russ,

    I believe that based on the requirements that were posted in the link above that GP would need to be GP 2013 R2.

    Hope the information that was posted has been helpful!

    ~Thomas Newcomb
    ------------------------
    Dynamics GP Support
    ------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September 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