Get error when attempting to Configure Distribution on a SQL Server 2014 Machine

Question

Get error when attempting to Configure Distribution on a SQL Server 2014 Machine

Welsh Corgi

SSC Guru

Points: 116520
More actions
February 9, 2016 at 12:00 pm

#315810

I Get the following error when attempting to Configure Distribution on a SQL Server 2014 Machine
ServerName\Instance Cannot be configured for publishing and distribution. Publishing and distribution are supported in SQL Server version 7.0 or later.
I looking for a work around.
Not sure why I'm getting this error?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

The snarky answer based on everything you posted above is: You are doing something wrong.

How about walking us through the steps you are using, that may give someone a better idea as to what may be going on with your setup.

Jacob Wilkins One Orange Chip Points: 27976 More actions · Answer 2

Is the version of SSMS you're using older than the instance you're connected to?

I know people have run into this issue a few times. In that case, configuring it via script would likely work; just a quirk of having an older SSMS connected to a newer instance.

Here's one example: http://blogs.msdn.com/b/sqlserverfaq/archive/2015/07/28/error-configuring-distribution-quot-publishing-and-distribution-are-supported-only-in-sql-server-version-7-0-or-later-quot.aspx

Cheers!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I installed SQL Server 2014 and I right clicked on Replication and Selected Configure Distribution and I get that error.

It is very basic. :laugh:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Jacob Wilkins (2/9/2016)
Is the version of SSMS you're using older than the instance you're connected to?
I know people have run into this issue a few times. In that case, configuring it via script would likely work; just a quirk of having an older SSMS connected to a newer instance.
Here's one example: http://blogs.msdn.com/b/sqlserverfaq/archive/2015/07/28/error-configuring-distribution-quot-publishing-and-distribution-are-supported-only-in-sql-server-version-7-0-or-later-quot.aspx
Cheers!

Good catch.

Thanks! 🙂

Edit: I was using 2012 SSMS.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/