Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / December 2005

Tip: Looking for answers? Try searching our database.

SQL Server 2005 Publication to MSDE

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TCorp - 21 Dec 2005 22:44 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.