Azure Database Migration Service - Super Privilege permission

Question

Hi! I am currently migrating from single to flexible. But I am experiencing this error when setting up the migration service.

Error:
Your source server is either not ready to be upgraded to the Flexible Server platform, or the service failed to connect. Please check error details for more information.", "errorDetail":"Insufficient permission on source server to acquire a global read lock and set the server to read only. The user is missing the 'SUPER' permission." }
Why I am requiring to have a super user permission. Currently I am using the created user when you are creating a database server which is an admin.

Thanks.

Answer 1

Hi @Khristian Dave Poleracio , Thanks for providing additional information.

Apologies for the inconvenience as this is a known issue with DMS, you can’t use that checkbox with a Single Server source since we have no way to obtain superuser permissions to change it to read-only.  Instead, you can use the portal and put the server into read-only mode yourself (via the read_only server parameter), prior to running the migration.

There was an update done where DMS removes the option to set the server to read-only when the project is configured with a Single Server source from the DMS portal.

Hope this information helps. Please let us know if any further queries.

Regards

Geetha

Answer 2

Additional info for your reference.