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

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 데이터베이스 마이그레이션 서비스 마이크로소프트 SQL 서버 데이터베이스

언어

English

Sanjeev_K

질문됨 9달 전446회 조회

2개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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. :)

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.

전문가

Jose Guay

답변함 9달 전

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

관련 콘텐츠