This topic describes the cause and solution of the message "The source database account does not have the sysadmin permission" that appears during a precheck.

Issue description

When you configure a task to migrate incremental data from an SQL Server database, the error message "The source database account does not have the sysadmin permission" appears during the precheck.
Note Sysadmin is the system administrator.

Possible causes

The source database of the incremental data migration task is an SQL Server database, and the source database account does not have the sysadmin permission. To migrate incremental data, the source database account must have the sysadmin permission. Otherwise, the logs of the source database cannot be obtained. For more information, see Limits on databases (data migration).

Solutions

Grant the sysadmin permission to the source database account:
  • If the source database is a self-managed SQL Server database, grant the sysadmin permission to the account.
  • If the source database is an ApsaraDB RDS for SQL Server database, grant the sysadmin permission to the account by performing the following steps:
    1. Contact Alibaba Cloud technical support and provide your Alibaba Cloud user identifier (UID).
    2. Log on to the ApsaraDB RDS console. Click the name of the ApsaraDB RDS for SQL Server instance.
    3. Choose Accounts > Create Account. In the Create Account panel, set Account Type to Privileged Account.
    Note