Not able to add dc_admin role to admin user on RDS for SQL Server

0

I'm working on building custom data collection sets in RDS for SQL Server (NOT RDS Custom for SQL Server). RDS SQL limit even admin user to execute msdb system stored procedures like 'sp_syscollector_create_collection_item'. Logged in with admin login and tried creating a new user and adding dc_admin role in msdb database to new user. But getting the error "Cannot alter the role 'dc_admin', because it does not exist or you do not have permission." Any idea how can I add data collector roles to users or creating custom data collection sets?

AWS
已提问 7 个月前931 查看次数
1 回答
0

Data Collector is one of the features that is not supported in RDS SQL Server. As a result related roles are not supported either.

AWS
已回答 7 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则