Merge replication between SQL Server 2008 and SQL Server 2005

• SQL Dev-938873

  Ten Centuries

  Points: 1280

  More actions

  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

• Ramesh @ SQLCentral

  SSC Veteran

  Points: 246

  More actions

  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).

• SQL Dev-938873

  Ten Centuries

  Points: 1280

  More actions

  August 3, 2010 at 3:19 am

  #1201403

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

  Thank You 🙂

  GaNeSH