DB Replication

marianaprm

I have two Navision Databases for eg DB1 and DB2. I have a Replication between DB1 and DB2 where DB1 is the publisher and DB2 the subscriber.
Here are some configurations we've done :
- 16 Nav Tables are being replicated.
- Publication Type is Transactional with updatable subscriptions.
- Table Article Properties are all set False exept Copy INSERT,UPDATE and DELETE sp.
- We are conecting to the subscriber using a SQL Login.
- BD's security model is "Standard"

Everything was working fine until the moment we've added a new SQL Login. The new login is created in DB1 and DB2 with role super.
When i try to modify a record in one of the replicated tables in DB2 i'm getting an error:

---

Microsoft Dynamics NAV

---

The combination of user ID and password entered is invalid. Try again.

---

OK

---

Could anyone help me please?

DenSter

marianaprm wrote:

- Publication Type is Transactional with updatable subscriptions.

Don't do this, you are asking for problems. With NAV you should not use two way replication.

marianaprm

Changing the publication to "Transactional publication" i don't get any error but the problem is that those are interface tables and i nedd to update/delete records in DB2(subscriber db). We are using Replication now instead of Views, we've had some problems with that before.
Thanks again

kine

Problem is, that the update will not trigger Business Logic of NAV thus can lead to big problems... [-X