We're planning on upgrading our SQL Server 2000 publisher to 2005. It has
several MSDE pull subscriptions. I am trying to get Northwind as a
Publisher to one MSDE subscriber but I've been having lots of difficulty.
I have created the publication and the pull subscription, but the subscriber
cannot synchronize. I get the following errors on the subscription
(Replication Monitor):
Error messages:
The process could not connect to Subscriber 'TCORP'. (Source: MSSQL_REPL,
Error number: MSSQL_REPL20084)
Get help: http://help/MSSQL_REPL20084
Named Pipes Provider: Could not open a connection to SQL Server [2].
(Source: MSSQLServer, Error number: 2)
Get help: http://help/2
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: 2)
Get help: http://help/2
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 'Northwind' 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)
And the job history displays the following error message:
The schema script 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\ReplData\unc\SQLSERVER_NORTHWIND_NORTHWIND\20051221120390\snapshot.pre'
could not be propagated to the subscriber. The step failed.
Checking the Surface Area Configuration Tool, it seems that the server is
set to allow Remote Connections, I even tried synchronizing with the TCP/IP
and Names Pipes setting set.
Please help, what can be going on?
Hilary Cotter - 22 Dec 2005 03:55 GMT
Pull can't read the local snapshot folder which is not a share. Make it a
share and then this should work.

Signature
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
> We're planning on upgrading our SQL Server 2000 publisher to 2005. It has
> several MSDE pull subscriptions. I am trying to get Northwind as a
[quoted text clipped - 41 lines]
>
> Please help, what can be going on?
TCorp - 28 Dec 2005 16:33 GMT
Thanks Hilary, I'll give that a try.
-Ted.
> Pull can't read the local snapshot folder which is not a share. Make it a
> share and then this should work.
[quoted text clipped - 44 lines]
>>
>> Please help, what can be going on?