RDS/SQL SERVER USER MANAGEMENT

When your destination MS SQL Server is RDS and you do not want to use the root account, provided by AWS, for replication purposes, we recommend the following script (different for source and destination servers) to be used to create a new user to be used for replications:

Execute below script under the root account of the SOURCE RDS/SQL Server. Use it for replication:

Execute below script under the root account of the DESTINATION RDS/SQL Server. Use it for replication:

DB replicas must be used in read-only mode. We recommend using below script to create a read-only user:

Execute below script under the account used for replication (the replicationUser in (1.2) above). It will create a new READ-ONLY user that has access to all databases under the new account:

 

Be the first to comment on "RDS/SQL SERVER USER MANAGEMENT"

Leave a comment

Your email address will not be published.


*