0

Microsoft SQL Server 2008 (SP1) Standard running on Windows 2008. Bidirectional transactional replication is set up between two servers. One of the subscription agents just started getting error 15164. The results of sp_helpsubscriptionerrors is: Source: MSSQL_ENG Error: 15165 Text: Could not find object '(null)' or you do not have permission. Command Id: 320

I have made sure that the SQL Server agent login has both Windows and SQL security access. Full access to the directory structure and sysadmin access to the SQL Server.

What else can I do to try to troubleshoot/fix this?

Thanks!

Improve this question

1 Answer 1

Reset to default
1

If you’ve validated the permissions as it sounds like you have, the cause could the performing of an operation on a non-existing object. To identify which object, run a profiler trace while reproducing the error. Look for “could not find object” error text so you can identify which object is missing. For example, a sp_MSrepl procedure could be missing.

Improve this answer
1
  • A profiler trace! Why didn't I think of that? Thank you sir.
    – Ryan
    Mar 17, 2011 at 18:18

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .