By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Assistance Required for MS SQL RDS Master User Permission Issue

0

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.

Topics
Database
Tags
Database
Language
English
Qe-Solar
asked 5 months ago202 views
1 Answer
0

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

Here is a documentation page that explains that into detail.

AWS
adrian-AWS
answered 5 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

Relevant content