Have you tried to allow named pipes and
Remote tcpip connections on

That subscriber?? And then

Restart the sql server service.?


simon qu

MCSE 2003,MCTS 2005,MCDBA 2000,CCNA

-----Original Message-----
From: Pete Ocasio [mailto:mssqldba-ezmlmshield-x72860150.[Email address protected]
Sent: Friday, 28 December 2007 1:28 AM
To: LazyDBA Discussion
Subject: Error while synchronizing merge replication for first time

I am trying to run the replication merge agent for the first time for a
replication. Several servers already replicate to the same server
without
problems. I have replicated all the previous Publishers to my subscriber

with the identical setup with the exception of the user login into the
server. The user login sees the appropriate tables in the subscriber yet
the
first synchronization errors with the following:

rror messages:

The process could not connect to Subscriber 'hera'. (Source: MSSQL_REPL,

Error number: MSSQL_REPL20084) Get help: http://help/MSSQL_REPL20084
Named
Pipes Provider: Could not open a connection to SQL Server [53].

(Source: MSSQLServer, Error number: 53)

Get help: http://help/53

An error has occurred while establishing a connection to the server.

When connecting to SQL Server 2005, this failure may be caused by the
fact
that under the default settings SQL Server does not allow remote
connections. (Source: MSSQLServer, Error number: 53) Get help:
http://help/53 Login timeout expired (Source: MSSQLServer, Error number:
0)
Get help: http://help/0 The merge process failed to execute a query
because
the query timed out.

If this failure continues, increase the query timeout for the process.

When troubleshooting, restart the synchronization with verbose history
logging and specify an output file to which to write. (Source:

MSSQLServer, Error number: 0)

Get help: http://help/0

The subscription to publication 'PUB_1' could not be verified. Ensure
that
all Merge Agent command line parameters are specified correctly and that
the
subscription is correctly configured. If the Publisher no longer has
information about this subscription, drop and recreate the subscription.

(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201019) Get help:
http://help/MSSQL_REPL-2147201019

Have any of you seen this error before? Do you know of a possible
solution?

Thank you,

Pete Ocasio

Senior Software Developer

Thank you,

Pete Ocasio
Senior Software Developer


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page