Azure Database Migration Service - Super Privilege permission

Khristian Dave Poleracio 131 Reputation points
2023-01-26T03:51:58.22+00:00

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.

Azure Database Migration service
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 25,682 Reputation points Microsoft Employee
    2023-01-27T19:02:54.76+00:00

    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


1 additional answer

Sort by: Most helpful
  1. Khristian Dave Poleracio 131 Reputation points
    2023-01-27T06:16:29.3166667+00:00

    User's image

    Additional info for your reference.

    0 comments No comments