SQL Transactional Replication Error

Distribution agent failing with below error.

Error : The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.

To Troubleshoot this issue, just follow below steps.

Checked with inactive replication subscriptions by running below script on Publisher Distribution database.

Use Distribution

go

Select * From distribution..MSsubscriptions

Checked with status of the subscription. If status = 0 (Its Inactive). We need to make status = 2 (Active)

Executed below script to make subscription status = 2.

update distribution..MSsubscriptions set status=2

Next start the distribution agent and refresh the jobs to check the Distribution job status.