Dynamics NAV 2009 sp1 and Sql Server 2000

zutzu

Can Dynamics NAV 2009 sp1 run with Sql Server 2000?

Marije_Brummel

No, it is not supported.

Personaly I would not run such a new business critical application on a platform that old.

zutzu

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).

kine

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.

Marije_Brummel

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

zutzu

Thanks

DenSter

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.

matttrax

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.

zutzu

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.

Thanks