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
Multiple Service Tiers – NAV 2009 SP1
Freddy have update his blog about how to run multiple service tiers in NAV 2009 SP1. One of the new things in SP1 is that you can use named instance of SQL server. On the blog post he has some nice bat script that can set everything up.
The post can be found here http://blogs.msdn.com/freddyk/archive/2009/08/05/multiple-service-tiers-sp1.aspx
Online resource for Dynamic NAV
Found this pages today
Dynamics book online.
A wiki with a lot of information about dynamics NAV
http://wiki.dynamicsbook.com/index.php?title=Main_Page
Microsoft Dynamics NAV 2009 Developer and IT Pro Help
The Microsoft Dynamics NAV 2009 Developer and IT Pro Help provides information about developing, installing, and managing Microsoft Dynamics NAV 2009. The latest help includes new content that describes new functionality in Microsoft Dynamics 2009 SP1. If you are not yet running SP1, a prior version of the help, which does not include Microsoft NAV 2009 SP1 functionality, is also available.
http://www.microsoft.com/DownLoads/details.aspx?familyid=EEC997BE-50C8-4D27-8BF2-FA93C9AC282A&displaylang=en
Installing Dynamics NAV 2009 on windows 7
In 2009 it’s not possible to-do a demo installation out of the box. Before starting the NAV installation you need to install SQL server since the version shipped with NAV 2009 doesn’t work on windows 7. When SQL server is installed you can run the NAV installer normally. This problem should be fixed in NAV 2009 SP1.
SQL server express SP3 32 bit http://go.microsoft.com/fwlink/?linkid=65212
SQL server express SP3 64 bit http://go.microsoft.com/fwlink/?linkid=83387
Multiple Service Tiers in Dynamics NAV 2009
Freddy have posted an interesting blog about having multiple service tiers.
From the post “A very typical scenario with both partners and customers is to have more than one database. This can be because you have a development database and a production database – or it could be the partner having a copy of all customer databases locally for troubleshooting.
You could of course install the Service Tier locally on all computers – and then change the CustomSettings.config to point to a new database every time you need to logon, but that doesn’t really sound like something we want people to do.
The setup we would like to have is:
• One or more SQL Server boxes with a bunch of databases on
• One or more Service Tier boxes with at least one Service Tier pr. database
• The Client installed locally on all machines being able to connect to these Service Tiers.
This post will go into detail about how to accomplish this.”
Failed to open key when Installing Dynamics NAV 2009
When installing Dynamics NAV 2009 one of my friend’s rune into this problem:
—————————————————————————–
Microsoft Dynamics NAV 2009 Build 27808
Error Report
RoleTailored client
Microsoft Dynamics NAV 2009 RoleTailored client
Fatal error during installation.
Could not open key: UNKNOWNMSComDlg.CommonDialog.1CLSID. Verify that you have sufficient access to that key, or contact your support personnel.
—————————————————————————–
The problem here is that we have a mismatch of .NET. The simplest solution is to install latest version of a .NET and run the installer again.
Trace flag in SQL Server for Dynamics NAV 2009
When starting the RTC client or open the database in classic client you will get a warning if you have not set the trace flag correct. Because of changed security in SQL Server 2005 Dynamics NAV 2009 will only connect to the SQL Server if the trace flat ‘4616’ is set.
How to:
1. Open SQL Server Configuration Manager
2. Right click on MSSQLSERVER and select properties
3. In properties click advanced tab
4. Click to the right of Setup Parameters and go to the end of the line
5. Add this string “;-T4616”
6. Click ok and restart your SQL Server.
Failed to execute SQL string when Installing Dynamics NAV 2009 #2
When reinstalling Dynamics NAV 2009 or if you have attached a Demo Database manually you will probably run into this problem:
—————————————————————————–
Microsoft Dynamics NAV 2009 Build 27808
Error Report
SQL Server option
Cronus Sample Database for Microsoft Dynamics NAV 2009
Fatal error during installation.
Error -2147467259: failed to execute SQL string, error detail: A database with name Demo Database NAV (6-0) already exists., SQL key: StopIfDatabaseExist SQL string: IF EXISTS (SELECT * FROM [master].[sys].[databases] WHERE name = ‘Demo Database NAV (6-0)’) RAISERROR (N’A database with name %s already exists.’,20,1,’Demo Database NAV (6-0)’) WITH LOG
—————————————————————————–
Read more
Installing stored procedures for Dynamics NAV 2009 manually
It’s recommended that you use the installer on the product DVD to install the stored procedures. But if you are running more than one name instance of SQL server on the same machine that approach will not work. Then you need to-do it manually:
1. Copy the xp_ndo.dll file to the location you want store it. The file can be found under “D:SQLDatabasePFilesMicrosoft Dynamics NAV60Database” on the product DVD.
2. Run the following SQL command to add the stored procedures.
USE master
EXEC sp_addextendedproc xp_ndo_enumusersids, ‘C:[Location of file]xp_ndo.dll’
GO
GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO
USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, ‘C: [Location of file]xp_ndo.dll’
GO
GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO
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.
Read more