Merge Replication Error

[aomara]

I have a Merge replication between 2 servers on 128 Mbit line.(Distanse between sites is about 700 KM.)

I am using SQL Server 2000.

the replication was working good except for the following problems:
--========================================================

1) Could not connect to the ditination server, and this is happen sometimes. even I can ping the distination server.

The process could not connect to Subscriber 'LY-MBK-MMS-03'.
(Source: LY-MBK-MMS-03 (Agent); Error number: 20084)
---------------------------------------------------------------------------------------------------------------
The merge process timed out while making a connection. Reconfigure the LoginTimeout parameter and retry the operation.
(Source: LY-MBK-MMS-03 (Data source); Error number: 0)
---------------------------------------------------------------------------------------------------------------

--========================================================

2) The Merge Agent recently return this error frequently

The process could not query row metadata at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200996)
---------------------------------------------------------------------------------------------------------------
Could not find stored procedure ''.
(Source: LY-MBK-MMS-03 (Data source); Error number: 2812)
---------------------------------------------------------------------------------------------------------------
The process was successfully stopped.
(Source: Merge Replication Provider (Agent); Error number: -2147200996)
---------------------------------------------------------------------------------------------------------------

So could you please help..
1) How to Increase the connection Time Out ? becasue I think this is the cause of problem 1

2) Any solution for Problem 2 ?

 

[mrdenny]

If I remember correctly, LoginTimeout is a paramater within the replication job step that you can set. Edit the job through the agent as if it was a regular job. You can change the paramater from in there.

With a 128 Meg line you shouldn't have any problems running replication unless the line is at capacity.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[aomara]

Many thanks for you interset.

Could you please provide more explanation.

The Job of the Merge Replication Agent contains 3 steps.

What is this paramater and under what step to put it ?

 

[mrdenny]

I haven't used replication is a couple of companies. If I remember correctly it's the second step. Check the job history. It will which ever step is failing. That paramater is probably already there. You should just need to update it.

If it doesn't work, you can always remove it.



Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com