该进程无法执行“sp_replcmds”在<服务器名称>上
我在测试服务器上设置事务复制时遇到很多麻烦。我正在运行 SQL Server 2008 SP2。
我能够创建交易出版物。快照代理工作正常，订阅发布也工作正常。我遇到的问题是日志读取器代理失败并出现错误：
The process Could notexecute 'sp_replcmds' on [ServerName]
快照和日志读取器代理在具有域管理员权限和 sysadmin 权限的 Windows 帐户下运行SQL 服务器。我还尝试在 SQL 代理配置文件下运行代理。我尝试执行 sp_replflush 并重新启动 SQL 代理。我还尝试将 -LoginTimeout 增加到 500，将 -ReadBatchSize 增加到 10。
非常感谢任何帮助。
I am having a lot of trouble setting up transactional replication on my test server. I am running SQL Server 2008 SP2.
I am able to create a transactional publication. The snapshot agent works fine and subscribing to the publication works fine as well. The problem that I get is that the log reader agent fails with the error:
The process could not execute 'sp_replcmds' on [ServerName]
The snapshot and log reader agents are run under a windows account with administrator privileges on the domain and sysadmin privileges on the sql server. I have also tried running the agents under the SQL agent profile. I have tried executing sp_replflush and restarting the SQL agent. I have also tried increasing -LoginTimeout to 500 and -ReadBatchSize to 10.
Any help greatly appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
有几个原因可能导致此问题，但对我来说最近的问题是两个数据库均由域帐户拥有。当我将它们都切换为“sa”拥有时，它就被修复了。
There are a few reasons that can cause this, but for me recently the problem was that both databases were owned by a domain account. As soon as I switched them both to owned by "sa", it was fixed.
您可以尝试将输出详细级别更改为 4 以查看任何其他信息。如果它是单个事务，则更改 readbatch 大小将无济于事。
Can you try changing output verbose level to 4 to see any additional info.chnanging readbatch size will not help if it is a single transaction.