How can i create a user on AWS MSSQL Read replica

0

Hi,

As far as I know, AWS RDS does not sync the user creation on replicadb. I created a user on the main db. However, the user has not been synced on the replica. I tried to create the user on Replica. I received a read-only exception. The question is, how can we create a database user on AWS RDS MSSQL read replica?

Thanks for the answers.

Efe
asked a month ago134 views
2 Answers
1
Accepted Answer

Greetings, Efe,

Please find the answer to your question in our official documentation?

Let me know if you need additional assistance?

AWS
answered a month ago
profile picture
EXPERT
reviewed a month ago
  • Many thanks. Finally worked.

1

Hi,

Service documentation says: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html#SQLServer.ReadReplicas.ObjectSynchronization

Any logins, custom server roles, SQL agent jobs, or other server-level objects that exist 
in the primary DB instance at the time of creating a read replica are expected to be present 
in the newly created read replica. However, any server-level objects that are created in the 
primary DB instance after the creation of the read replica will not be automatically replicated, 
and you must create them manually in the read replica.

The page above details the procedure to replicate users created after the replica setup

Best,

Didier

profile pictureAWS
EXPERT
answered a month ago
profile picture
EXPERT
reviewed a month ago