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
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
- 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:
- Contact Alibaba Cloud technical support and provide your Alibaba Cloud user identifier (UID).
- Log on to the ApsaraDB RDS console. Click the name of the ApsaraDB RDS for SQL Server instance.
- Choose Privileged Account. . In the Create Account panel, set Account Type to
- For more information, see Create a system admin account for an ApsaraDB RDS for SQL Server instance.
- The privileged account has the sysadmin permission.