Replication: Version problem (2014-2016)

  • jeremie 98561

    SSChasing Mays

    Points: 608

    Hello everyone,

     I dig for a while to make my replication between my 2 servers

     I have an internal server on which runs a SQL Server 2014 that I would like to "synchronize" with my web server that runs with a SQL Server 2016.
     
    I am using the "merge publication".

     The problem is that when I want to create my subscription I have this message:
    For merge publications, the Subscriber version must not be later than the version of the publishing server.

     Yet if I trust this article I can publish and distribute with a 2016 and subscribe with a 2014, but I still have this error.
    https://blogs.msdn.microsoft.com/sql_server_team/upgrading-a-replication-topology-to-sql-server-2016/

    Internal Server (SQL Server 2014):
     
    Microsoft SQL Server Management Studio 12.0.5203.0
     
    Client Tools Microsoft Analysis Services 12.0.5203.0
     
    Microsoft Data Access Components (MDAC) 6.3.9600.17415
     
    Microsoft MSXML 3.0 6.0
     
    Microsoft Internet Explorer 9.11.9600.18538
     
    Microsoft .NET Framework 4.0.30319.42000
     
    Operating System 6.3.9600

    Web Server (SQL Server 2016):
     
    Microsoft SQL Server Management Studio 13.0.16000.28
     
    Microsoft Analysis Services Client Tools 13.0.1700.441
     
    Microsoft Data Access Components (MDAC) 6.3.9600.17415
     
    Microsoft MSXML 3.0 6.0
     
    Microsoft Internet Explorer 9.11.9600.18538
     
    Microsoft .NET Framework 4.0.30319.42000
     
    Operating System 6.3.9600

     thank you in advance

  • John Mitchell-245523

    SSC Guru

    Points: 148246

    You don't actually say on which server you created the publication?  By the way, the specifications you posted are for SSMS, not for the SQL Server database engine itself.

    John

  • jeremie 98561

    SSChasing Mays

    Points: 608

    I already tried with both, and I had the same error.

    How can I get the SQL Server database engine spécifications ?

  • John Mitchell-245523

    SSC Guru

    Points: 148246

    EXEC xp_msver

    Are you saying that whichever server you make the publisher, you attempt to create a subscription on the other and you get the same error message?  If that is the case then I think you've discovered a bug!

    John

  • jeremie 98561

    SSChasing Mays

    Points: 608

    Internal server :

    ProductName  Microsoft SQL Server
    ProductVersion 786432 12.0.5203.0
    Language 1036 Français (France)
    Platform  NT x64
    Comments  SQL
    CompanyName  Microsoft Corporation
    FileDescription  SQL Server Windows NT - 64 Bit
    FileVersion  2014.0120.5203.00 ((SQL14_PCU_main).160923-1620)
    InternalName  SQLSERVR
    LegalCopyright  Microsoft Corp. All rights reserved.
    LegalTrademarks  Microsoft SQL Server is a registered trademark of Microsoft Corporation.
    OriginalFilename  SQLSERVR.EXE
    PrivateBuild  
    SpecialBuild 340983808 
    WindowsVersion 340983808 6.3 (9600)
    ProcessorCount 8 8
    ProcessorActiveMask                ff
    ProcessorType 8664 
    PhysicalMemory 17997 17997 (18871259136)
    Product ID  

    Web server :

    ProductName  Microsoft SQL Server
    ProductVersion 851968 13.0.4001.0
    Language 1036 French (France)
    Platform  NT x64
    Comments  SQL
    CompanyName  Microsoft Corporation
    FileDescription  SQL Server Windows NT - 64 Bit
    FileVersion  2015.0130.4001.00 ((SQL16_PCU_Main).161028-1734)
    InternalName  SQLSERVR
    LegalCopyright  Microsoft. All rights reserved.
    LegalTrademarks  Microsoft SQL Server is a registered trademark of Microsoft Corporation.
    OriginalFilename  SQLSERVR.EXE
    PrivateBuild  
    SpecialBuild 262209536 
    WindowsVersion 262209536 6.3 (9600)
    ProcessorCount 2 2
    ProcessorActiveMask                 3
    ProcessorType 8664 
    PhysicalMemory 3072 3072 (3220754432)
    Product ID  

    Yes, I tried :
     - make the publisher with the internal and create subscription with web
     - make the Publisher with the web and create subscription with internel
    And I've the same error message :ermm:

  • John Mitchell-245523

    SSC Guru

    Points: 148246

    The subscriber version has to be less than or equal to the publisher version.  Therefore your Web server needs to be the Publisher.  I recommend that you research how to thoroughly remove whatever replication you currently have in place, and then set up again as I described.  The only reason I can think of that it didn't work before was that you didn't remove replication properly before switching the publisher and subscriber.

    John

  • jeremie 98561

    SSChasing Mays

    Points: 608

    To remove replication, I did it on both server :
     - delete Local Publications
     - delete Local Subscription
     - Disabled Publishing and Distribution (this removed linked jobs)

    Then I created a Local Publication on the web server with "Merge publication".
    Then, with my internal server I tried to create a new subscription, but when I selected my subscripting database, I had this message :
    "For merge publications, the Subscriber version must not be later than the version of the publishing server." (It's a translation from french 😉 )

    I dont'understand :crazy:

  • jeremie 98561

    SSChasing Mays

    Points: 608

    No more idea ? :crying:

  • John Mitchell-245523

    SSC Guru

    Points: 148246

    No, sorry.  Just make sure that you've removed all traces of replication, not just the ones you can see, and try again.  There's lots of resources that tell you how to do that, if you search for them.

    John

Viewing 9 posts - 1 through 9 (of 9 total)

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