开发者社区> 问答> 正文

rds sqlserver sp_cdc_enable_table 开启监控表的命令报错

rds sqlserver sp_cdc_enable_table 开启监控表的命令报错,报错信息如下: Could not update the metadata that indicates table [dbo].[zhoutao] is enabled for Change Data Capture. The failure occurred when executing the command '[sys].[sp_cdc_add_job] @job_type = N'capture''. The error returned was 916: 'The server principal "S-1-9-3-695758163-1316657335-127315332-3186711835" is not able to access the database "msdb" under the current security context.'. Use the action and error to determine the cause of the failure and resubmit the request. com.microsoft.sqlserver.jdbc.SQLServerException: SQLServerException: Could not update the metadata that indicates table [dbo].[zhoutao] is enabled for Change Data Capture. The failure occurred when executing the command '[sys].[sp_cdc_add_job] @job_type = N'capture''. The error returned was 916: 'The server principal "S-1-9-3-695758163-1316657335-127315332-3186711835" is not able to access the database "msdb" under the current security context.'. Use the action and error to determine the cause of the failure and resubmit the request.

展开
收起
ntbzbc6i542fi 2021-06-17 18:01:44 1012 0
0 条回答
写回答
取消 提交回答
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像