SQL Replication config failure

Question

When trying to setup SQL replication we're seeing this error? How do we go about fixing it?

===================================

SQL Server could not enable 'SERVERNAME\DBNAME' as a Publisher. (Microsoft.SqlServer.Rmo)

---

Program Location:

at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.EnablePublisher(Publisher publisher, Boolean bScripting)

at Microsoft.SqlServer.Management.UI.ConfigureDistributionWizard.InstallDistributor(Boolean& anyExceptions, Boolean bScripting, ApplicationException& outerEx, StringBuilder command)

===================================

Object was not found on server. Check if this object exists on the server. (Microsoft.SqlServer.Rmo)

---

Program Location:

at Microsoft.SqlServer.Replication.ReplicationObject.CommonCreate()

at Microsoft.SqlServer.Management.UI.ReplicationSqlConnection.EnablePublisher(Publisher publisher, Boolean bScripting)

Answer 1

Hi @mkea ,

>SQL Server could not enable 'SERVERNAME\DBNAME' as a Publisher. (Microsoft.SqlServer.Rmo)
>Object was not found on server. Check if this object exists on the server. (Microsoft.SqlServer.Rmo)

Did you using Replication Management Objects (RMO) to configure replication publication? According to your error message, please verify that the database exists.

Please check if you miss some steps follow the MS document Create a Publication.

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.