One of the questions that has been raised frequently is how to install the Dynamics NAV demo database to a named instance of Microsoft SQL Server using the new installation program that was released with Dynamics NAV 2009. The short answer to this question is that this is not supported. However, there is a work around that in fact will allow you to do this.
Before going into how this can be accomplished there are a few things I need to highlight.
Now with this in place let's proceed with the work around.
The task at hand is to install the Dynamics NAV 2009 demo database to a named instance of Microsoft SQL Server 2005. The name of the instance is "CRONUSDEMO" and has already been installed to the computer "CRONUSSERVER" with the service account "NETWORK SERVICE". The Microsoft Dynamics NAV 2009 installation media is located in the DVD drive of your computer (D:\), but it will also work if you install from a local folder or a network drive. You must have administrative privileges on the computer.
msiexec -I "D:\SQLDatabase\Microsoft_Dynamics_NAV_SQL_Database.msi" INSTANCENAME=CRONUSDEMO
msiexec -I "D:\SQLDatabase\Microsoft_Dynamics_NAV_SQL_DemoDatabase.msi" INSTANCENAME=CRONUSDEMO
The demo database is now installed and you should see two entries for this in the control panel.
To use the newly installed database with the Microsoft Dynamics NAV RoleTailored client you must manually set the Microsoft Dynamics NAV Server to connect to the SQL Server named instance. To do this you must edit the configuration file of the server.
You do not have to change any settings on the RoleTailored client in order to connect to the database.
- Michael Riddersholm Petersen
PingBack from http://NavigateIntoSuccess.com/blog/what-did-nav-bloggers-blog-in-january
Hi! I would like to create a new database on an SQL server instance which already has the Dynamics NAV demo database. I have done it using the NAV Classic Client with the SQL Server option, and then restoring a backup on it. The new database is accessible in both SQL Server and Dynamics NAV Classic Client with SQL Server option, what makes me thing that is all right. But I cannot load it on the RTC Client, and I have not found any response yet (I also tried to change the NAV Server configuration file in order to point to my database, but it doesn't work also).
Is it possible to create an issue on this blog with this topic?? Thanks!