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.