Assistance Required for MS SQL RDS Master User Permission Issue

Question

Hi,

We are currently encountering challenges with MS SQL RDS master user permissions. Our database is set up using the RDS service, and when running a query using sp_config, we are encountering a "permission denied" error.

Our research indicates that the user requires sysadmin permissions, but due to AWS limitations on RDS control, we are unable to grant the necessary permissions.

We kindly request your assistance and any insights you may have on resolving this issue.

Answer

In RDS SQL Server to change server configuration options you would use a custom parameter group.

Here is a [documentation](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithDBInstanceParamGroups.html
) page that explains that into detail.

Assistance Required for MS SQL RDS Master User Permission Issue

Contenido relevante