I am running replication from a clustered sql server to an instance of sql on a diff. box. When I performed failover on the source cluster replication broke. Publisher seems to work fine. However on the subscriber I get following error message:
Invalid object name 'tempdb.dbo.MSdistributor_access'. The step failed.
any idea how to troubleshoot this? Seems like there is not much on this online.
Where are you seeing this error?
This table (and a few others) are used to populate the information in Replication Monitor, and don't actually have anything to do with the replication process itself.
If you delete these files from Tempdb, and refresh Replication Monitor, they just get rebuilt.
I am seeing this in the job history as well as under the last action column of subscription window.
do you mean i should delete all the records from MSdistribution_access table or delete the table?
Delete the tables.
Don't forget, the tables are in Tempdb, so they will be removed every time you restart the instance, so you can do no harm by deleting the whole table.
'tempdb.dbo.MSdistributor_access' table might be marked as system table so that you can't delete it.