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

Question

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

Answer

is CREATE User or create Login ?

Answer

Hi there!

You are correct, this might have been missing from the instructions but you can safely create the user using the [CREATE USER](https://learn.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql?view=sql-server-ver16) command per the documentation, prior to granting the permissions.

I hope this helps.

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

Conteúdo relevante