question

PeterNolan-8796 avatar image
0 Votes"
PeterNolan-8796 asked PeterNolan-8796 answered

Cannot create replication through SSMS

Hello, I am having problems creating a SQL Server replica using SSMS

Microsoft SQL Server 2019 (RTM-GDR) (KB4583458) - 15.0.2080.9 (X64) Nov 6 2020 16:50:01 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)

Microsoft SQL Server Management Studio 14.0.17213.0
Microsoft Analysis Services Client Tools 14.0.1016.232
Microsoft Data Access Components (MDAC) 6.3.9600.17415
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.20016
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.9600

Through SSMS I select Replication -> Local Publications and New Publication

I then receive the error

TITLE: New Publication Wizard



You cannot create a publication from server 'LHR-NEXSC-S\NEXUM_STAGING' because the server is too old.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=14.0.17213.0&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=ServerTooOld&LinkId=20476


BUTTONS:

OK



Anyone seen this before and know what to do ?

Thanks

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

There are indeed a few things that are too old.

Microsoft SQL Server 2019 (RTM-GDR) (KB4583458)

You should apply CU10, which is the most recent cumulative update to get access to bug fixes since the release of SQL Server.

However, that is not why you get the error message. I think that rather the problem is SSMS. You have SSMS 17.x. I think you need SSMS 18.x here. Get it from
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PeterNolan-8796 avatar image
0 Votes"
PeterNolan-8796 answered

Thank you for your answer, I will try that. Oddly enough that is what I thought however when searching Microsoft the version I installed came up as the latest.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.