Merge Replication with Navision 3.70.01

sfi

We have two Navision Databases both Navision 3.70.01 on SQL Server 2000 with Windows Login.
Some of the tables are merge replicated between the two servers.
Users are setup identically on both servers both in SQL and Navision and they have identical Navision Roles on the two servers.
The problem is that the users can access the replicated tables from Navision on the Publisher, but access to the same tables from Navision on the subscriber is denied due to lacking SELECT Permission on the table.
The users must be added to the db_owner role in SQL Server to gain access.

Does anybody have an explanation and maybe a solution to this?

sfi

Now my friends.

The chalenge has been solved.
To make it work you must do the following on the Subscriber Database:

In SQL Enterprise Manager goto the Database, Roles.
In the Role Public give the necesarry permissions to the replicated tables:
Select, Insert, Update, Delete.

Then it works.

BUT the disadvantage in this is that now anybody with access to the database through ODBC will be able to make changes to these tables because it's no longer Navision that controls the permissions.

Best Regards,
Steen Fisker
Navision Developer since 1990

np

Hi there,

I am new to Navision. My company has multi-location offices and we have just started exploring Navision as our CRM system.

I would like to know how good replication works for Navision.

I understand that Navision does not have any built in support for replication so one has to use replication of SQL server. Correct me if I am wrong.

Also, please suggest is it better to go for single Navision database over VPN or to implement replication.

Thanks in anticipation.