Transactional Replication configuration

Question

Hi,

I am configuring a transaction on three servers (publication, distributor, subscriber). When I am trying to configure the publisher for a particular table I get the below error message.

Answer 1

Replication is not installed as a default. Did you install the option during setup?

Answer 2

Hi @kccrga ,

Using select @@version to check your SQL server version, SQL Express edition do not support transaction replication.

Did you use T-SQL or replication wizard to configure transactional replication? If you use T-SQL, did you use the correct context of database? You need to run add publisher script in context of distribution database. I suggest you use replication wizard to configure transaction replication, I think it is simple than T-SQL. You can follow the steps from this blog to configure transaction replication through SSMS UI.

If it is still not work using replication wizard, did the database is a restored database that previously had replication? You can try to use sp_removedbreplication to remove all replication components from a database.

Best regards,
Cathy

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.