How to install more than one Dynamics NAV 2009 Demo Database

By default when you are installing the demo database by the installation program you can only install one Demo Database. But if you would like to have more than one Demo Database to try different things in, how to accomplish that? I assume that you know that you can create a new company in the classic client, but you will then not get the demo data. The solution is simple to use SQL Server Management Studio to attach more than one version of the Demo Database.

  1. Stop the SQL Server
  2. Make a copy the database files in "C:\Program Files\Microsoft Dynamics NAV\60\Database" to new location. For example "C:\NAVTestDB\"
  3. Start the SQL Server
  4. Start SQL Server Management Studio and connection to the instance where you have installed the other Demo Database.
  5. Right click on "Databases" and select "Attach" and click "Add". Then pick the database file that you did copy to new location.
  6. Change the "Attach As" column for the new Demo Database file to "NAVDEMO"
  7. Press OK
  8. Update the Microsoft Dynamics NAV server configuration file to use the new database by open "CustomSettings.config" file in notepad. The file is normally located under "C:\Program Files\ Microsoft Dynamics NAV\60\Service".
  9. Locate the DatabaseName key.
  10. Change the value attribute to "NAVDEMO"
  11. Restart the "Microsoft Dynamics NAV Server" service in the Windows Service manager
Comments (2)

  1. Lawrence says:

    How do i stop the SQL server?

  2. Mohamad Vajid says:

    Go to the SQL Server Configuration Manager under Configuration Tools from the Programs menu. Once open, click on SQL Server Services on the left hand pane. You will have a SQL Server (MSSQLSERVER) on the right hand pane. Right click and Stop.

Skip to main content