SQL Server 2008 复制失败:进程无法执行“sp_replcmds" [英] SQL Server 2008 replication failing with: process could not execute 'sp_replcmds'

问题描述

我遇到了 SQL 复制问题，但无法修复.我正在做的是从生产备份中恢复两个数据库，然后在它们之间安装复制.复制的配置似乎没有任何错误，但是当我查看状态时，我看到如下错误消息:

I have an issue with SQL replication that I am having trouble fixing. What I am doing is restoring two DBs from a production backup, and then installing replication between them. The replication seems to be configured without any errors, but when I look at the status I see error messages like this:

错误信息:

进程无法执行MYSERVER1"上的sp_replcmds".得到帮助:http://help/MSSQL_REPL20011

The process could not execute 'sp_replcmds' on 'MYSERVER1'. Get help: http://help/MSSQL_REPL20011

不能作为数据库执行主体因为主体dbo"不存在，这种类型的主体不能被冒充，或者你没有获得许可.(来源:MSSQLServer，错误编号:15517)获取帮助:http://help/15517

Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Source: MSSQLServer, Error number: 15517) Get help: http://help/15517

进程无法在MYSERVER1"上执行sp_replcmds".获取帮助:http://help/MSSQL_REPL22037

The process could not execute 'sp_replcmds' on 'MYSERVER1'. Get help: http://help/MSSQL_REPL22037

这是什么意思?

推荐答案

当我遇到这个问题时，我的数据库没有正确设置所有者.我从另一个 Windows 域恢复了一个数据库，右键单击数据库 -> 属性并在常规"选项卡中验证所有者设置正确.但是，在文件"选项卡中，根本没有设置所有者.我设置后，复制运行没有问题.

When I had this problem, my database didn't have an owner set properly. I had restored a database from another windows domain, right clicked the database -> properties and verified in the "general" tab that the owner was set correctly. However, in the "files" tab, owner was not set at all. As soon as I set it, replication was running without problems.

这篇关于SQL Server 2008 复制失败:进程无法执行“sp_replcmds"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！