Setting up ongoing replication on a standalone SQL Server: Without sysadmin role

0

Hi ,

I need to create the SQL server user with minimum permissions to configure the ongoing replication.

We plan to migrate the SQL server databases to AWS using DMS+CDC when I am checking the AWS document(https://docs.aws.amazon.com/dms/latest/userguide/CHAP_SupportScripts.SQLServer.html#CHAP_SupportScripts.SQLServer.standalone).

in the 9th step, The user(DMS_user) is not created but he/she is trying to provide the permissions to the User, does we/aws missed to create the user(DMS_user) or is something missing from me.

Source: SQL Server Target: RDS SQL server Tool: DMS+CDC

2 Answers
0

is CREATE User or create Login ?

answered 10 months ago
  • You would need to create a login first. Use CREATE USER if you have a login, or use CREATE LOGIN if you don't have one already which will create a user as well. Both cases are covered in the examples on the pages I shared.

    I hope this helps. :)

0

Hi there!

You are correct, this might have been missing from the instructions but you can safely create the user using the CREATE USER command per the documentation, prior to granting the permissions.

I hope this helps.

profile pictureAWS
EXPERT
answered 10 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions