Was able to figure this out.. We were using the Database User instead of the Database SID..
Incorrect ::
select count(*) from LINK_TO_AR_DB..CCM_USER.CCM_PDL_ProductDictionaryPatch
Correct ::
select count(*) from LINK_TO_AR_DB..ARSystem.CCM_PDL_ProductDictionaryPatch