Sql-server – Replication Configuration

replicationsql serversql server 2014sql-server-2012

I had a SQL Server 2008 Express edition as a Default instance and I am having SQL Server 2012 Evolution and SQL Server 2014 Evolution are my named instances. When I was trying to configure Replication on my SQL Server 2014 as a Distributor as well as Publisher, I am getting the following error:

'NITHYAN\DBA2014' cannot be configured for publishing and
distribution. Publishing and distribution are supported only in SQL
Server version 7.0 or later.

If I am trying to configure on SQL Server 2012 as Distributor as well as Publisher it allow me to do Replication.

I don't understood what's wrong with SQL Server 2014.
Why do I get the above error?

Best Answer

Downlevel versions of SSMS cannot always connect to uplevel versions of SQL. When configuring replication, please ensure you are using the version of SSMS from your Distributor. In your case, based on the error message, you are using the SSMS from the Express version of SQL. Instead, use the version from your Distributor instance.