Error: The source database account lacks the sysadmin permission-Data Transmission Service(DTS)-阿里云帮助中心

This topic explains how to resolve the "source database account lacks sysadmin permission" error, which can occur during a precheck.

Issue

When you configure an incremental data migration task from a SQL Server source database, the precheck fails and reports that the source database account lacks the sysadmin permission.

Note The sysadmin permission grants system administrator privileges.

Cause

The account for the incremental data migration task lacks the sysadmin permission on the SQL Server source database. This permission is required to access database logs for ongoing replication. For more information, see Usage notes and limits for data migration.

Solution

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 instance, follow these steps to grant the sysadmin permission:
1. Contact Alibaba Cloud technical support and provide your Alibaba Cloud UID.
2. Log in to the ApsaraDB RDS for SQL Server console and click the name of the SQL Server instance.
3. Click Accounts > Create Account and select Privileged Account.
Note
- For detailed instructions, see Create a System Admin account for an ApsaraDB RDS for SQL Server instance.
- A Privileged Account has the sysadmin permission.