Regresar
-
Título
Permissions error when installing, adding, or verifying an agent with SQL Server Express on Amazon RDS -
Descripción
The following error message is encountered when attempting to connect to an SQL Server Express edition instance on Amazon RDS using the SQL Server cartridge.
[Foglight][SQL Server JDBC Driver][SQLServer]Cannot alter the role 'SQLAgentUser Role', because it does not exist or you do not have permissions.
-
Causa
The SQL Server Express edition does not have the agent job feature. The installation error is received when the permission script attempts to grant permissions for the agent job list collection. -
Resolución
WORKAROUND
Skip the grant process and then disable the Agent Job List collection.
STATUS
The 5.9.4.20 cartridge for SQL Server presently only supports the standard and enterprise editions of SQL Server.
The express edition is presently not supported for RDS monitoring.