How to fix the above error in SQL Server Replication:
In a nutshell:
1. Select * from MSsubscriptions
2. update distribution..MSsubscriptions set status=2 where publisher_id='x'
and
publisher_db='x' and publication_id='x' and subscriber_id='x' and
subscriber_db='x'