Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
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

Themen
Migration und ModernisierungDatenbank
Tags
Migration und ModernisierungAWS Datenbank-MigrationsdienstMicrosoft SQL ServerDatenbank
Sprache
English
Sanjeev_K
gefragt vor 9 Monaten446 Aufrufe
2 Antworten
0

is CREATE User or create Login ?

Sanjeev_K
beantwortet vor 9 Monaten
  • Jose Guay EXPERTE
    vor 9 Monaten

    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
EXPERTE
Jose Guay
beantwortet vor 9 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt