16

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

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
Geo
  • 3,160
  • 6
  • 41
  • 82

2 Answers2

18

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.

Bruce P
  • 19,995
  • 8
  • 63
  • 73
  • can you suggest a workaround for this issue then? I am trying to add data to my production database through a query which run on my development database.... any clues? – Geo Feb 20 '15 at 15:45
  • I'm not all that familiar with MSSQL. Can you do a backup and restore as described [here](http://stackoverflow.com/questions/5026990/best-easiest-way-to-make-a-sql-server-dump-and-import-that-dump-in-another-sql)? – Bruce P Feb 20 '15 at 16:38
  • 1
    You can use AWS DMS to do replication instead. – Muhammad Rehan Saeed Jan 17 '18 at 12:32
-1

I think you need to create a separate user with the appropriate permissions with a query. Similar question with answer here: https://serverfault.com/questions/496966/amazon-rds-sql-server-master-user-privileges

Community
  • 1
  • 1