Assistance Required for MS SQL RDS Master User Permission Issue

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.

トピック

データベース

タグ

データベース

言語

English

Qe-Solar

質問済み 5ヶ月前230ビュー

1回答

新しい順
投票が多い順
コメントが多い順

これらの回答は役に立ちましたか？コミュニティがあなたの知識を活用できるように、正解に賛成票を投じてください。

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.

adrian-AWS

回答済み 5ヶ月前

Qe-Solar
5ヶ月前
Thanks for the respond, can you check this? https://stackoverflow.com/questions/70749675/admin-user-cant-enable-contained-database-sql-server
adrian-AWS
5ヶ月前
The stackoverflow answer is correct. While you cannot get sysadmin privileges on RDS, you can change server configuration like 'contained database authentication' through parameters. Please refer to the documentation page above.

Assistance Required for MS SQL RDS Master User Permission Issue

関連するコンテンツ