Thursday, January 18, 2007

General Network error - cannot connect to subscriber db

Today Jan 18, 2007, I found out the the SQL Server Distributor, cannot connect to the subscriber machine probably for a day or two. The following error message log from the distributor machine tells us that there is a communication failure between the distributor and the subsriber.

Because of these communication problem, between the servers data are not transmitted to FCPHIL.

Communication link failure
(Source: SUBSCRIBERDB-XXX (Data source); Error number: 0)
---------------------------------------------------------------------------------------------------------------

The process could not connect to Subscriber 'SUBSCRIBERDB-XXX'.
(Source: SUBSCRIBERDB-XXX (Agent); Error number: 20084)
---------------------------------------------------------------------------------------------------------------
SQL Server does not exist or access denied.
(Source: SUBSCRIBERDB-XXX (Data source); Error number: 17)
---------------------------------------------------------------------------------------------------------------


The process could not enumerate changes at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
---------------------------------------------------------------------------------------------------------------
General network error. Check your network documentation.
(Source: SUBSCRIBERDB-XXX (Data source); Error number: 11)
---------------------------------------------------------------------------------------------------------------
The process was successfully stopped.
(Source: Merge Replication Provider (Agent); Error number: -2147199469)
---------------------------------------------------------------------------------------------------------------

No comments: