Replication Monitor could not connect to Distributor

Hello Guys,

I have the following scenario:

PC1 : located in Dubai representing my laptop

PC2: located in Denver ,

Both pcs are connected to each other via the internet as i am using Aliases ,they can both access and see each other using SQL Auth.

I want to implement Merge Replication to Synchronize TestDB ,

I have NO DOMAIN connnecting them.

I Created a new publication ,under security i asked the agent to use the Sa account to connect

When launching the rep monitor i get the following error:

"Replication Monitor could not connect to Distributor 'laptop'."

"Login failed for user ''. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)"

Both Publisher and Distributer are on my Laptop ,why cant they connect to each other?

Another Question : could i implement Traditional Merge replication to synchronize my DBs or do i need to configure Web Synch in Merge rep to enable connecting via the internet?!

Thanks Guys!

Moodi

First off while you are free to use web synchronization where appropriate you probably can use traditional merge replication.

It is probably that you have configured replication monitor to connect to your distributor with an account which does not have the necessary rights to monitor SQL server. Can you ensure that SQL Server is able to authenticate using mixed authentication (right click on it, select properties, select security and ensure that SQL Server and windows authentication is selected. Add an account in the sysadmin role or verify you know the sa password. Then right click on your distributor in Replication Monitor and select remove. Then right click and add it again, this time use the sa account and its password to add it.|||

Thanks Hillary,

i was able to fix this by configuring the property of the connection used to connect to distributer ,it was windows auth. so i changed it to run under SQL auth. now replication monitor can run and show all subscribers but i have another problem.

I get the following error when i try to initialize the subscription located on my USA server :

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.1.1]
2007-07-05 11:55:11.00 Logon Error: 18456, Severity: 14, State: 11.

Please note that i am using merge replication via the internet with out web synch. ,when i run the SQL Agent under the local system account i get the above mentioned error although i configured Sa account with the same pwd to be used on both machines.

I created a windows account RepUser on both machines as part of Admin group ,then i configured the agent on both machines to run under this account ,i got the following error:

Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.1]
2007-07-05 11:55:06.15 Logon Error: 17806, Severity: 20, State: 2.

Looks like the SQL agent process account is the one thats being authenticated and NOT the Sa account ,why is this happening?

|||

Hi Ali

I am a little lost here, but it sounds like you need to configure your publication to use a ftp snapshot and then configure ftp for anonymous authentication.

HTH

|||

Hello Hilary ,

Are u saying that if i have two mahcines replicating via the internet then i should have the snapshot folder accessible via FTP?

Ali