Msg 20032, Level 16, State 1, Procedure distribution.dbo.sp_MSadd_subscription, Line 175 [Batch Start Line 0] 'AGLISTENER,54321' is not defined as a Subscriber for 'SERVER1\INSTANCE1'. Msg 14070, Level 16, State 1, Procedure sys.sp_MSrepl_changesubstatus, Line 1249 [Batch Start Line 0] Could not update the distribution database subscription table. The subscription status could not be changed. Msg 14057, Level 16, State 1, Procedure sys.sp_MSrepl_addsubscription_article, Line 384 [Batch Start Line 0] The subscription could not be created. Msg 20021, Level 16, State 1, Procedure sys.sp_MSrepl_addpushsubscription_agent, Line 258 [Batch Start Line 0] The subscription could not be found.
Similar error will happen if you upgrade the remote distributor to SQL 2019. It is a bug fixed in CU5 released last week.
Assuming you have a replication environment like this
- Publisher: SERVER1/INSTANCE1
- Distributor: SERVER2/INSTANCE2
- Subscriber: AGLISTENER,54321
The script to reproduce the issue is:
-- Publisher create database pub_test go
use pub_test create table test(a int primary key, b varchar(255)) go exec sp_replicationdboption @dbname = N'pub_test', @optname = N'publish', @value = N'true' exec sp_addpublication @publication = N'test', @repl_freq = N'continuous', @status = N'active', @independent_agent = N'true' exec sp_addpublication_snapshot @publication = N'test' exec sp_addarticle @publication = N'test', @article = N'test', @source_owner = N'dbo', @source_object = N'test' go -- Susbcriber create database sub_test go -- Publisher exec sp_addsubscription @publication = N'test', @subscriber = N'AGLISTENER,54321', @destination_db = N'sub_test', @subscription_type = N'Push' exec sp_addpushsubscription_agent @publication = N'test', @subscriber = N'AGLISTENER,54321', @subscriber_db = N'sub_test'