使用 AWS re:Post 即表示您同意 AWS re:Post 使用條款
AWS re:Postre:Post

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

主題
遷移與現代化資料庫
標籤
遷移與現代化AWS Database Migration ServiceMicrosoft SQL Server資料庫
語言
English
Sanjeev_K
已提問 9 個月前檢視次數 446 次
2 個答案
0

is CREATE User or create Login ?

Sanjeev_K
已回答 9 個月前
  • Jose Guay 專家
    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
專家
Jose Guay
已回答 9 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋，同時有助於提問者的專業成長。

回答問題指南

相關內容