How to install more than one Dynamics NAV 2009 Demo Database alternative 2
Earlier I did describe how to duplicate an installed and existing database in post “How to install more than one Dynamics NAV 2009 Demo Database”. This time I will attached the DB directly from DVD.
The steps is as follow
1. Create the directory where you would like to have the new database.
2. Copy the database from DVDSQLDemoDatabasePFilesMicrosoft Dynamics NAV60Database Demo Database NAV (6-0)_Data.mdf to the new directory.
3. Run the following command in SQL manager studio and replace the @physname path with the new created on and set @dbname to the database name you would like to use.
sp_attach_single_file_db @dbname= ‘new_Demo Database NAV (6-0)’, @physname= ‘C:Program Files (x86)Microsoft Dynamics NAV60Database – CopyDemo Database NAV (6-0)_Data.mdf’
You need to ensure that the SQL server user have correct permissions to ‘C:Program Files (x86)Microsoft Dynamics NAV60Database – Copy’ or where you put the db files. I’m using ‘NETWORK SERVICE” as the SQL server user account, the NAV will use this account by default when doing demo installation.
To set permission
1. Open properties for the directory.
2. Click security tab
3. Click advance
4. Click edit
5. If the SQL server user is not present press add and pick the user else select the SQL server user and click edit
6. Change the permission so that the following permission is checked
a. Read attributes
b. Read extended attributes
c. Create files / write data
d. Create folders / append data
e. Write attributes
f. Write extended attributes
g. Delete subfolders and files
h. Delete
7. Click OK
8. Click Ok
9. Click OK
10. Click OK
Hi Peter,
You really have a great blog, but I didn’t see it until today.
I’m not really sure about the purpose of either the above tip or the one you wrote in may.
Isn’t the real not that you cannot run more than one database at once and that you cannot start two different local database at once like you can with the classic client? At least as a developer you very often have this requirement.
In the Navision Developer FAQ on DUG I have written a few tips on how you can setup your PC to run more than one database with NAV 2009.
http://dynamicsuser.net/wikis/navdev/how-can-i-access-multiple-databases-from-the-dynamics-nav-roletailored-client.aspx
Your updates or input to the FAQ is very welcome…
Yes you can create a new database in classic client and use it in RTC. The difference here is if you would like to keep the demo data for testingdeveloping purpose. In classic client you can only create database, company and import objects.