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

Issue

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

Cause

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).

Solution

Grant the sysadmin permission to the source database account:
  • If the source database is a user-created SQL Server database, grant the sysadmin permission to the account based on the actual scenario.
  • 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. Go to the ticket system and submit a ticket. Submit the ID of your Alibaba Cloud account to the technical support personnel.
    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 System Admin Account.
    Note