NAV 2009 with SQL Server 2008 R2 - Express

arunjan387

Hello,

I installed SQL Server 2008 R2 Express Edition on my server. Then I restored the NAV database backup on this server. I tries to open the database from NAV 2009 Client. The application manages to trace the database on the specified server but it says that the database has been upgraded by the current version of SQL Server and hence it says that NAV 2009 must also be upgraded to a compatible version.

Could anyone please help me to find a solution for this?

Thank you

lvanvugt

I am not really into this, but I recall (and tried to get the right info on this) that NAV 2009 SP1 (and R2) is only compatible with SQL Server 2008 R2. The only info I could find that seems to support this is:

CustomerSource: Microsoft Dynamics NAV Compatibility with Microsoft SQL Server 2008 R2

PartnerSource: Microsoft Dynamics NAV Compatibility with Microsoft SQL Server 2008 R2

In short it's saying:

We support the following versions of Microsoft Dynamics NAV with Microsoft SQL Server 2008 R2:

* Microsoft Dynamics NAV 2009 SP1
* Microsoft Dynamics NAV 5.0 SP1 with Update 2

bbrown

NAV 2009 R2 is support on SQL 2005, SQL 2008, and SQL 2008 R2. While 2005 is out of mainstream support, conversation I've had with MS support state they do support it. Of course, that is subject to change and you're always best to use the latest release.

mdPartnerNL

Ok so to confirm SQL Server "Express" and SQL Server "Compact" are out?

bbrown

I've run small test/development databases just fine on Express. I just would not use it for production due to its limitations.

lvanvugt

bbrown wrote:

I just would not use it for production due to its limitations.

These are of course context dependent. Please read the comments here: SQL Server 2008 Express #1: the free database engine from Microsoft.

bbrown

lvanvugt wrote:

bbrown wrote:

I just would not use it for production due to its limitations.

These are of course context dependent. Please read the comments here: SQL Server 2008 Express #1: the free database engine from Microsoft.

Agreed.

BTW - Express is not extirely free. Only the server is. You still need CALs for any workstations.

arunjan387

Thank you everyone for the support. I found a solution for that. SQL Server 2008 R2 Express works fine with NAV 2009 SP1.