Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
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

Temas
Migración y modernizaciónBase de datos
Etiquetas
Migración y modernizaciónServicio de AWS Database MigrationMicrosoft SQL ServerBase de datos
Idioma
English
Sanjeev_K
preguntada hace 9 meses446 visualizaciones
2 Respuestas
0

is CREATE User or create Login ?

Sanjeev_K
respondido hace 9 meses
  • Jose Guay EXPERTO
    hace 9 meses

    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
EXPERTO
Jose Guay
respondido hace 9 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante