Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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!

share|improve this question

1 Answer 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.

share|improve this answer
    
A profiler trace! Why didn't I think of that? Thank you sir. –  Ryan Mar 17 '11 at 18:18

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.