question

mkea avatar image
0 Votes"
mkea asked Cathyji-msft commented

SQL Replication config failure

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @mkea,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.