CODEWITHSUNDEEP
sql-serveramazon-web-servicesamazon-rds
Ivan Gritsenko
Ivan Gritsenko

Reputation: 4226

Why master user that was created when configuring RDS has no sysadmin role on created server?

I've started RDS SQL Server. At that moment a master user was created as well. I can connect to my SQL server with SQL management studio. The question is why doesn't my user have sysadmin role?

enter image description here

Upvotes: 1

Views: 1757

Answers (1)

E.J. Brennan
E.J. Brennan

Reputation: 46879

Its one of the tradeoffs when using SQL Server on RDS, you don't get complete administrator-level access to the server.

This page tells you the restrictions you will have:

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html

enter image description here

Upvotes: 5

Related Questions