mibuso.com
Home› SQL General
Options

Compatibility of Dynamics NAV with SQL Server 2008 R2

strykstryk Member Posts: 645
edited 2010-11-24 in SQL General
Hi there,

is there any official statement available (from Microsoft) regarding prerequisites and compatibility of NAV with "SQL Server 2008 Release 2" ?

Same actually applies to "Windows Server 2008 R2" ...

Cheers,
Jörg
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool

Comments

  • Options
    bbrownbbrown Member Posts: 3,268
    This was the response I got from MS in early June.

    “We will provide support for SQL 2008 R2 no later than 90 days after the RTM of SQL 2008 R2. We are currently in the process of testing the product”
    There are no bugs - only undocumented features.
  • Options
    strykstryk Member Posts: 645
    Hmmm ... OK, thanks for the info. So there should be some official statement within a couple of weeks ...
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • Options
    mgrzymalamgrzymala Member Posts: 2
    after moving my NAV 5.0 database from sql 2008 to sql 2008 R2 the clients connecting from Windows 2000 machines started losing connections (aplication error: connection to the server lost ...), XP and higher are fine
  • Options
    bbrownbbrown Member Posts: 3,268
    Received this from Microsoft this morning:

    "NAV R&D team has completed the verification for running Dynamics NAV 2009 SP1 with SQL Server 2008 R2. An official announcement will be posted on PartnerSource and CustomerSource shortly."
    There are no bugs - only undocumented features.
  • Options
    kinekine Member Posts: 12,562
    https://mbs.microsoft.com/partnersource ... .htm?p=186
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    ezhikusezhikus Member Posts: 21
    Hi!

    I`ve encountered a problem with NAV 5.0 SP1 on SQLServer2008R2 64/WindowsServer2008R2 64.
    We`ve used 5.0SP1 on a SQL2005SP3 and everything was fine, but when i restored same base on a SQLServer2008R2 64/WindowsServer2008R2 64 machine, NAV refuses to connect and gives that trace flag 4616 error. But 5.0SP1 no longer needs it, right?

    Will trace flag solve my problem?
    Thanks in advance.
    for mother russia!
  • Options
    strykstryk Member Posts: 645
    5.0 SP1 still need TF 4616. This requirement is void with NAV 2009 SP1.
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
Sign In or Register to comment.