Dynamics NAV 2009 sp1 and Sql Server 2000

zutzuzutzu Member Posts: 86
edited 2009-09-11 in SQL General
Can Dynamics NAV 2009 sp1 run with Sql Server 2000?


  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    No, it is not supported.

    Personaly I would not run such a new business critical application on a platform that old.
  • zutzuzutzu Member Posts: 86
    But, does Dynamics NAV 2009 sp1 work with Sql Server 2000?
    I have a small customer (5 licenses) running Sql Server 2000 and Dynamics NAV 5. It´s a basic installation.
    They will not use RTC.
    He is thinking about update to Dynamics NAV 2009 sp1 but they don´t want to update Sql Server 2000 (money).
  • kinekine Member Posts: 12,562
    Already NAV 5.00SP1 is not compatible with SQL 2000 because the change in SIFT technology, where NAV is using indexed views now. Same is for NAV 2009.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    It works. But it does not perform.

    the number of users is not a measurement for a small installation. I've analysed a 50GB database with 8 users last week.

    http://blogs.msdn.com/microsoft_dynamic ... -2000.aspx
  • zutzuzutzu Member Posts: 86
  • DenSterDenSter Member Posts: 8,304
    I just want to point out that SQL Server 2000 is no longer supported by Microsoft. The mere fact that someone has a working NAV2009 database on this version of SQL Server does not mean that it will work in all instances. When you do get a problem (when, not if), you will be on your own. You will not only have enormous cost from consultants to come in and help you, but you will end up having to pay for a SQL Server upgrade after all.

    If you need to use NAV2009, you need to upgrade SQL Server to version 2005 or 2008. Might as well do it now, because you'll end up having to do it anyway.
  • matttraxmatttrax Member Posts: 2,309
    Are you sure SQL 2000 works with NAV 2009 at all? I accidentally tried to open a 2000 Database with a 2009 client one time and it said the database was on an unsupported version. I think to upgrade to 2009 you have to upgrade SQL.
  • zutzuzutzu Member Posts: 86
    I tried to open a Sql server 2000 Database with a 2009 client and it said the database was on an unsupported version, too.
    I will have to tell to the customer that he must upgrade Sql Server if he wants to work with NAV 2009 sp 1.

Sign In or Register to comment.