Whenever there is an error as mentioned above then, you can try to update the status column in the MSsubscriptions table in the distribution database. The status column for the expired subscription indicated a value of 0 meaning inactive. The value of 2 in the status column means Active.
Try the following steps:
1.
Select *
from MSsubscriptions to locate the expired subscription.
2. Use the query below to reset the status in MSsubscriptions table. Fill in the values for the publisher_id, publisher_db, publication_id, subscriber_id and subscriber_db in the query below with the values from the expired subscription in the MSsubscriptions table.
update distribution..MSsubscriptions
set status=2
where publisher_id=
'x' andpublisher_db=
'x' and publication_id=
'x' and subscriber_id=
'x' and subscriber_db=
'x'Status of the subscription:
0 = Inactive
1 = Subscribed
2 = Active
