Error configuring distribution- "Publishing and distribution are supported only in SQL Server version 7.0 or later"

 

I recently installed an instance of SQL Server 2016 on one of my server. Later when I tried to configure the new instance as Distributor I faced the below error:

Error:

clip_image002

------------------------------
TITLE: Configure Distribution Wizard
------------------------------
'Prod\SQL16' cannot be configured for publishing and distribution. Publishing and distribution are supported only in SQL Server version 7.0 or later.
For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.0.2000.8&EvtSrc=Microsoft.SqlServer.Management.UI.ConfigureWizardErrorSR&EvtID=ServerTooOld&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

 

Observations:

  • From the Object Explorer I can clearly see that I’m connected to the latest version of SQL[SQL 2016] but still I’m getting the above error.

 

clip_image002[6]

 

clip_image002[8]

 

  • Tried to configure Distributor using the TSQL script and it successfully executed. After this when I tried to create a new publication I again got the same error. So the issue seems to be only with the GUI.

 

clip_image002[10]

clip_image002[12]

  • I then verified the version of SQL Server management studio which I was using and noticed that it was an older version- SQL 2014 SSMS.

clip_image002[14]

 

 

Solution:

  • I then launched SSMS for SQL Server 2016 and I was able to configure the instance as distributor. As mentioned before we can also use the TSQL commands to configure.

clip_image002[16]clip_image001clip_image001[5]

 

 

  • I faced this issue as I had multiple version of SQL server management studio on the same server

clip_image002[18]

· Configure Distribution https://msdn.microsoft.com/en-us/library/ms151860.aspx

· How to: Configure Publishing and Distribution (Replication Transact-SQL Programming) https://technet.microsoft.com/en-us/library/ms147363(v=sql.105).aspx

· How to: Configure Publishing and Distribution (SQL Server Management Studio) https://technet.microsoft.com/en-us/library/ms151192(v=sql.105).aspx

· sp_adddistributor (Transact-SQL) https://technet.microsoft.com/en-us/library/ms176028(v=sql.105).aspx

· sp_adddistributiondb (Transact-SQL) https://technet.microsoft.com/en-us/library/ms189755(v=sql.105).aspx

 

Author:

Raghavendra Srinivasan , Support Engineer, Microsoft India GTSC

Reviewed by:

Balmukund Lakhani, Support Escalation Engineer, Microsoft India GTSC