受管实例错误:此版本的SQL Server不能充当复制的发行者或发行者. [英] managed instance error:This edition of SQL Server cannot act as a Publisher or Distributor for replication.

问题描述

 我试图在托管实例上配置事务复制.

 I trying to configure transaction replication on my managed instance.

 我遵循了配置.向导来配置分发，但出现错误

 I followed config. wizard to configure distribution but got error 

此版本的SQL Server不能充当复制的发行者或发行者."

"This edition of SQL Server cannot act as a Publisher or Distributor for replication."

 我看到分发数据库已创建，

  I see that distribution database is created , 

 我以为这可能是SSMS GUI错误，但是当我尝试创建发布时却遇到了相同的错误

  I thought that it could be SSMS GUI bug ,but when I tried to create publication I got the same error

 当我尝试从已保存的脚本中重新运行它时

  when I try to rerun it from saved script 

使用母版
exec sp_adddistributor @distributor = N'DEVMYSQL1.CAA111111111111111.DATABASE.WINDOWS.NET'，@password = N''

use master
exec sp_adddistributor @distributor = N'DEVMYSQL1.CAA111111111111111.DATABASE.WINDOWS.NET', @password = N''

我得到警告:不支持引用原始服务器的链接服务器.如果您希望使用由四部分组成的名称来引用本地表，请使用实际的服务器名称而不是别名.

I get Warning: A linked server that refers to the originating server is not a supported scenario.  If you wish to use a four-part name to reference a local table, please use the actual server name rather than an alias.

然后下一行

exec sp_adddistributiondb @database = N'distribution'，@data_folder = N'C:\ WFRoot \ DB.2 \ Fabric \ work \ Applications \ Worker.CL_App13 \ work \ Data'，@log_folder = N'C:\ WFRoot \ DB.2 \ Fabric \ work \ Applications \ Worker.CL_App13 \ work \ Data'，@log_file_size = 2，@min_distretention = 0，@ max_distretention = 72，@ history_retention = 48，@ deletebatchsize_xact = 5000，@ deletebatchsize_cmd = 2000，@ security_mode = 1
开始

exec sp_adddistributiondb @database = N'distribution', @data_folder = N'C:\WFRoot\DB.2\Fabric\work\Applications\Worker.CL_App13\work\Data', @log_folder = N'C:\WFRoot\DB.2\Fabric\work\Applications\Worker.CL_App13\work\Data', @log_file_size = 2, @min_distretention = 0, @max_distretention = 72, @history_retention = 48, @deletebatchsize_xact = 5000, @deletebatchsize_cmd = 2000, @security_mode = 1
GO

产生错误

推荐答案

请考虑，则分发数据库和复制代理不能放置在SQL数据库上. SQL数据库必须 成为SQL Server发布者的推送订阅者.有关更多要求和限制，请阅读以下文章:

Please take in consideration, the distribution database and the replication agents cannot be placed on SQL Database. SQL Database must be a push subscriber of a SQL Server publisher. For more requirements and limitations, please read the following article:

希望这会有所帮助.

问候，

Alberto Morillo
SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于受管实例错误:此版本的SQL Server不能充当复制的发行者或发行者.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！