November 12, 2007 at 6:48 am
Hi NG
PUBLISHER: Win2003 EE R2, SQL 2005 Std
SUBSCRIBER: Win2000 (SP4), SQL 2000 Std (SP3a)
I need to do a merge replication between SQL2000 (Subscriber) and SQL 2005
(Publisher/Distributor).
Using FTP, I am able to set up a pull subscription from another SQL 2005
box.
I now need to set up the same replication, but from a SQL2000 box.
In SQL 2000, we used the client network utility to set up an alias. We then
registered the alias in EntMngr, and set up the pull subscription.
However, we are unable to set up the replication to the SQL2005 box, as we
need a registered server in order to do so.
==========================================
A connection could not be established to GENHS001.
Reason: [SQL-DMO]You must use SQL Server 2005 management tools to connect to
this server..
===========================================
Any help is greatly appreciated
Des Norton
November 12, 2007 at 7:22 am
Configure the replication using SQL 2005 Management Studio rather than using Enterprise Manager. You can do this either by setting up the entire replication from the 2005 side, or by installing Managemenr Studio on the 2000 server or just a workstation somewhere.
You can register both servers in Management studio and this will make things far easier for you.
In addition, the Replication screens in 2005 are much better than they were in 2000 so the job should be easier this way.
November 12, 2007 at 7:27 am
Hi,
You cannot use SQL Serverr 2000 EE to connect to a SQL Server 2005 instance. To setup your subscription from the SQL Server 2000 (e.g. pull), you will need to either install the SQL Server 2005 tools on subscriber or use replication stored procedures to configure subscriber for publication. Here are the two proc's you will need:
Publisher = sp_addmergesubscription
Subscriber = sp_addmergepullsubscription
You can get the syntax of both commands on-line in BOL.
Thanks,
Phillip Cox
November 13, 2007 at 7:40 am
Mihael, Philip
Thanks of the input.
I have tried using the SPs to add the subscription manually, but still no luck.
I have carte blanche on the publisher/distributor (my server), but need lots of grease to get anything added/changed at the subscriber.
I have registered both servers in SSMS on the publisher, where I can interact fully with the subscriber. Using SSMS, I connect to the subscriber and add a new push subscription.
However, I get the following error:
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script 'exec dbo.sp_MSchange_mergepublication @pubid = 'C033C52F-E647-4486-8BDB-E3C5A4469686', @property = allow_subscription_copy, @value = 'true'' could not be propagated to the subscriber.
2007-11-13 14:35:19.250 Percent Complete: 0
2007-11-13 14:35:19.250 Category:NULL
Source: Microsoft SQL Native Client
Number: 2812
Message: Could not find stored procedure 'dbo.sp_MSchange_mergepublication'.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply