Post reply

Merge replication between SQL Server 2008 and SQL Server 2005

  • July 20, 2010 at 11:49 pm

    #224271

    Hi Everybody,

    I want to configure merge replication between SQL Server 2008 and SQL Server 2005.

    Publisher : SQL Server 2008 with 64 bit

    Subscriber : SQL Server 2005 with 32 bit

    I have created publication on SQL server 2008 which subscribers can be SQL 2005 and Later Editions.

    But when i was trying to create subscriber on SQL Server 2005 ,

    I get the publisher from SQL Server 2008 which i have created earlier.

    When i add SQL Server Subscriber of the server 2005 its gives following error.

    "For merge replications, the version of the subscriber must not exceed the version of the subscriber"

    But Publisher is SQL Server 2008 and Subscriber is SQL Server 2005.

    The versions of i want to configure:

    SQL Server 2008 : Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)

    SQL Server 2005 : Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Please provide suggestions and solutions.

    Thanks in advance

    Regards

    GaNeSH

    GaNeSH

  • August 3, 2010 at 12:27 am

    #1201370

    Please check whether you are connecting SQL Server 2008 from ssms(SQL 2008 client) and not from sqlwb(SQL 2005 Client).

  • August 3, 2010 at 3:19 am

    #1201403

    I have identified the problem on next day of this post 🙂

    Thank You 🙂

    GaNeSH

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply