Hello Guys,
I have two machines that i want to use for merge replication :
Laptop ( Publisher + Distributor )
VPS90 ( Subscriber )
Both connected via the internet
NO DOMAIN
Need to implement merge replication ,after initializing the snapshot I get the following error on both machines :
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.1.1]
I created a new user "Repuser" (admin)with the same password on both machines and configured the Agent proccess to run under that account ,now i get this error :
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.1]
Please note that :
¡¤ Mixed mode authentication IS ENABLED ON BOTH MACHINES
¡¤ BOTH MACHINES CAN PING AND ACCESS EACH OTHER ,BOTH COMPLEETELY VISIBLE.
¡¤ CONFIGURED ALIASES ON BOTH MACHINES.
¡¤ Both configured to use Sa account .
* I have NO DOMAIN
what does this mean
It simply means that the SQL Server Agent process account is the one that¡¯s being authenticated to connect to the other machine and NOT the Sa account ,WHY
do i have to use Web Synch in my case