Must be enable as a Publisher

Error

I installed SQL Server 2017 on Centos 7 and used MSSM GUI for database replication configuration.

when the distribution configuration process was successful until the end but when creating a publisher, the problem started when I right clicked on

replication > New > Publication… and an error appeared as below

must be enable as a Publisher before you can create a publication. In the following dialog box. enable this server as a pblisher.

Solution

On SQL Server 2017 and earlier versions. It is not possible to create replication using IP addresses. With SQL Server, you can connect to the engine using ServerName, like:

example1:

servername

-- For instance name server
example 2:
servername\instancename

example 3:
servername\MSSQLSERVER2017

Don’t use IP addresses, just what you need. Then you see Boom, everything is good, and a new publication has been created.