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.”
Error 1935 when installing Dynamics NAV 5.0 SP1
When I did try to install the NAV 5.0 SP1 client I run into an error 1935. This may happen on Vista and Windows 2008. Don’t know if Windows 7 also have this problem.
Error 1935; an error occurred during the installation of
assembly component {98CB24AD-52FB-DB5F-A01F-C8B3B9A1E18E}. HRESULT:0x800736CC.
The solution is simpler then it seems. You need to install Microsoft Visual C++ 20005 SP1 Redistributable pack. Remember if you are running on a 64 bit system you need to install both x86 and x64 package.
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