Azure Database Migration Service - Super Privilege permission

Khristian Dave Poleracio 131 Reputation points

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

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.


Azure Database Migration service
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 25,682 Reputation points Microsoft Employee

    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.



1 additional answer

Sort by: Most helpful
  1. Khristian Dave Poleracio 131 Reputation points

    User's image

    Additional info for your reference.

    0 comments No comments