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달 전929회 조회
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달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인