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
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.