Using SQL Server 2008 Express in Dynamics NAV 2009

NAV 2009 will install SQL Server Express 2005 by default if no SQL server is installed. So if you would like to use SQL Server Express 2008 instead, this is the way to go:

The Demo installation of NAV 2009 is looking for a SQL Server instance called MSSQLSERVER. If the installer can’t find this instance SQL Server Express 2005 will be installed and the Demo Database will be attached to SQL Server 2005 even though you might have had SQL Server Express 2008 installed.
So to install on SQL Server Express 2008 you need to set the instance name to MSSQLSERVER. This way NAV 2009 will install the Demo Database on SQL Server 2008.

Note: SQL Server 2008 requires the following:
.NET Framework 3.5 SP1
Windows Installer 4.5
Windows PowerShell 1.0 (Included in Windows Vista SP1 and Windows Server 2008)

0.00 avg. rating (0% score) - 0 votes

About Peter Wibeck


One Response to “Using SQL Server 2008 Express in Dynamics NAV 2009”
  1. salman says:

    Thanks to this article i was able to install NAV 2009 on windows 7.

    Thank you very much Peter.

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!