Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
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:
------------------------------
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]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/02/65/metablogapi/3288.clip_image0026_286BAF60.jpg "clip_image002[6]")
- Verified that I’m not connected to Web/SQL Express edition which supports Subscriber only. More info at Features Supported by the Editions of SQL Server 2016
![clip_image002[8]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/02/65/metablogapi/3000.clip_image0028_575382A6.jpg "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]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/02/65/metablogapi/3326.clip_image00210_48ADF823.jpg "clip_image002[10]")
![clip_image002[12]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/02/65/metablogapi/7633.clip_image00212_2BC9F4B0.jpg "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]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/02/65/metablogapi/5635.clip_image00214_33E3B1B6.jpg "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]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/02/65/metablogapi/1411.clip_image00216_12F56071.jpg "clip_image002[16]")
![clip_image001[5]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/02/65/metablogapi/5344.clip_image0015_498ABDC8.jpg "clip_image001[5]")
- I faced this issue as I had multiple version of SQL server management studio on the same server
![clip_image002[18]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/02/65/metablogapi/1057.clip_image00218_2D12ED4A.jpg "clip_image002[18]")
Related Articles:
· 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
Comments
- Anonymous
September 17, 2015
Thanks for you explanation. I got same issue. Now it's got resolved.