February 24, 2017 at 8:28 am
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
February 24, 2017 at 8:44 am
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
February 27, 2017 at 4:30 am
I already tried with both, and I had the same error.
How can I get the SQL Server database engine spécifications ?
February 27, 2017 at 4:42 am
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
February 27, 2017 at 5:35 am
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:
February 27, 2017 at 5:45 am
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
February 27, 2017 at 6:25 am
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:
February 28, 2017 at 12:39 am
No more idea ? :crying:
February 28, 2017 at 2:09 am
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 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply