SQL 2022 Express Replication with error

Mcgoldrick, Dennis 0 Reputation points
2026-07-16T19:01:05.7966667+00:00

The error says "The process could not connect to Publisher"

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bruce (SqlWork.com) 84,671 Reputation points
    2026-07-18T15:56:06.54+00:00

    Because it does not have SQL Agent support, SqlServer Express only supports pull subscriptions. You set up a batch file to do the replication and use a job scheduler to run the batch file. see:

    https://learn.microsoft.com/en-us/sql/relational-databases/replication/synchronize-a-pull-subscription?view=sql-server-ver17

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.