What is causing Error 15165 in my MSSQL Transactional Replication subscription agent?
- by Ryan
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!