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
asked 10 months ago984 views
1 Answer
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
answered 9 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions