Multiple NAV servers with different country versions

gorgavel · 2011-09-05

We are going to install 4 different country versions for a customer on a server.
Then we will set up 4 NAV servers and 4 databases.
Is that possible? How?
I have read about setting up multiple NAV Servers and that is not the problem.
But is it possible to install 4 different country versions on a server?

Marije_Brummel · 2011-09-05

Yes, it is possible, I have at least 4 countries installed on my laptop.

But beware of the collation issues. You might run into conflicts when the server is for example Latin1 and the countries have different collations. Still this is no problem for SQL Server, but the server will have to do collaction changes, especially in TempDB.

gorgavel · 2011-09-05

Thanks for Your answer.
(just what I wanted to hear!)

kriki · 2011-09-05

And don't forget that each country has its own license. So they all need the granule "license per database" otherwise only 1 license is loaded for all the databases in the server. And county X cannot access objects belonging to country Y.

mdPartnerNL · 2011-09-05

kriki wrote:

And don't forget that each country has its own license. So they all need the granule "license per database" otherwise only 1 license is loaded for all the databases in the server. And county X cannot access objects belonging to country Y.

For license reasons and if all companies are in the same database you must be right. But in the described situation with seperate database en per database a different license, do you still need that granule?

Marije_Brummel · 2011-09-05

No, the other way around.

Normally the license file is stored in the master database (AFAIK). With the granule kriki mentioned you can store the license file in the NAV database and thus have multiple countries on one server

DenSter · 2011-09-05

Just making sure we're getting this right:
Each SERVER can have one or more DATABASES. BY DEFAULT, for the SQL Server option, NAV licenses are loaded PER SERVER, and apply to all NAV databases on that server. On SQL Server, BY DEFAULT, the license file is stored in the Master database, in the "$ndo$srvproperty" table to be exact. All users in all NAV databases count toward the licensed number of users. So if you have two databases, with 10 users each, you will need to have a license for 20 users total.

It is possible to store NAV license inside the database, but you MUST have the granule in your license. If you need multiple localizations in separate databases, on the same server, you will have to purchase that granule in each license. If you have say a Dutch database with 10 users and a German database with 10 users, you will need a Dutch localized license for 10, and also a German localized license with 10 users, both with the "License Per Database" granule.

Each DATABASE can have one or more COMPANIES. Regardless of where the license is stored, ALL companies in each individual database will share the same objects, and the same license.

mdPartnerNL · 2011-09-06

Thank you for this explanation. The microsoft support had problems making this clear to me but now I understand. (I guess I understand

)

Sog · 2011-09-06

An ERD usually makes it easier to understand.

DenSter · 2011-09-06

And 'Database' is the alternate license location, but that can only happen if you have that granule.

gorgavel · 2011-10-04

Mark Brummel wrote:

Yes, it is possible, I have at least 4 countries installed on my laptop.

But beware of the collation issues. You might run into conflicts when the server is for example Latin1 and the countries have different collations. Still this is no problem for SQL Server, but the server will have to do collaction changes, especially in TempDB.

I am installion an a new server.
I have installed the swedish version.
I have stopped the service NAV Server
I have renamned the program catalog .../Microsoft Dynamics NAV SE/ to ... /Microsoft Dynamics NAV SVE/
Then I start the Norweigan installation BUT it goes into program cataloge /Microsoft Dynamics NAV SE/ and I cant change it. (The norweigan program tells me that it is already installed! There is no chice for new version)

What do I have to do to install the Norweigan version?

I think I found it out.
- Stop the service
- Rename Program cataloge
- Uninstall program Microsoft Dynamics NAV
- Create New Service
Then start again with next country version!

/Göran

Howdy, Stranger!

Quick Links

Categories

Multiple NAV servers with different country versions

Answers