Menu
I started using Amazon RDS and I am trying to link two of my databases together but I don't have the appropriate permissions to do it. When I setup the database for the first time is only letting me setup a regular user without sysadmin rights. Is there anyway of getting sysadmin rights? Also, there is a user rdsa (with sysadmin rights) but I don't have access to it since is something that I guess amazon added to my RDS instance automatically on creation. Any thought on that?
Edit: I am running a MS SQL Server
605
Your AWS RDS instance is at risk if you haven't changed its default master username. It is an alphanumeric name that is used to acquire access to the database instance. When a Relational Database Service instance is first created, there is a need to provide a username, which is the master username.
Use conditions in IAM policies to further restrict access – You can add a condition to your policies to limit access to actions and resources. For example, you can write a policy condition to specify that all requests must be sent using SSL.
Because RDS is a managed service they limit what you are able to do with it. According to the RDS documentation for MSSQL this includes the following restrictions:
The following server-level roles are not currently available in Amazon RDS:
bulkadmin
dbcreator
diskadmin
securityadmin
serveradmin
sysadmin
And also:
Amazon RDS currently does not support the following SQL Server features:
...
Replication
Even if they did support replication for MSSQL it would likely be limited to replicating with other RDS instances. With MySQL they only support replication between RDS instances, so if/when they support it with MSSQL it will likely have similar restrictions.
102
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
