开发者社区> 问答> 正文

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 1014 0
0 条回答
写回答
取消 提交回答
问答排行榜
最热
最新

相关电子书

更多
TcpRT:阿里云RDS智能诊断系统云上大规模部署自动化服务的客户实践经验 立即下载
TcpRT:面向大规模海量云数据库的服务质量实时采集与诊断系 立即下载
袋鼠云基于阿里云RDS的数据库架构实践 立即下载

相关镜像