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回答
0

is CREATE User or create Login ?

回答済み 9ヶ月前
  • 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
エキスパート
回答済み 9ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ