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
preguntada hace 7 meses929 visualizaciones
1 Respuesta
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
respondido hace 7 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas