SQL Replication config failure

mkea 1 Reputation point
2021-04-14T23:53:38.797+00:00

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)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,607 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 21,071 Reputation points Microsoft Vendor
    2021-04-15T03:22:14.437+00:00

    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.

    0 comments