0

I'm using one MSSQL server (SQL server 2019 on Linux, to be precise, on Kubernetes) as a distributor and publisher. I tried to configure it as a transactional publication using SSMS. The problem that I'm facing is when I try to configure a new publication. I'm getting an error (as shown in the screenshot). SQL server 2019 publication error

Here are the errors:

Messages
SQL Server Management Studio could not create article 'Country'. (New Publication Wizard)

------------------------------
ADDITIONAL INFORMATION:

Cannot create if this object represents an existing object in the server. (Microsoft.SqlServer.Rmo)
 
SQL Server Management Studio could not create article 'Currency'. (New Publication Wizard)

------------------------------
ADDITIONAL INFORMATION:

Cannot create if this object represents an existing object in the server. (Microsoft.SqlServer.Rmo)
 
SQL Server Management Studio could not create article 'Product'. (New Publication Wizard)

------------------------------
ADDITIONAL INFORMATION:

Cannot create if this object represents an existing object in the server. (Microsoft.SqlServer.Rmo)
 
SQL Server Management Studio could not create article 'Segment'. (New Publication Wizard)

------------------------------
ADDITIONAL INFORMATION:

Cannot create if this object represents an existing object in the server. (Microsoft.SqlServer.Rmo)

I have tried to rerun it multiple times, and I have even tried to publish only tables, but in the end, I always end up with the same error.

I would appreciate your help!

Improve this question
1
  • I have managed to make it work by disabling the tables with names B.Country, B.Currency, B.Product, and B.Segment and only keeping the primary ones A.Country, A.Currency, A.Product, and A.Segment. But I would like to have both A.x and B.x tables.
    – iRakic
    Mar 13 at 22:30

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.