"EXECUTE (or SELECT) permission was denied on the object" error in Business Central cloud migration

This article solves permission-related errors that might occur when running the Cloud Migration Setup assisted setup guide in Business Central, which is part of the data migration process from on-premises to Business Central online.

Symptoms

When you run the Cloud Migration Setup assisted setup guide in Business Central, you receive one of the following error messages:

• The EXECUTE (or SELECT) permission was denied on the object.

• User does not have permission to perform this action.

Cause

The SQL login account used by the self-hosted integration runtime to access the on-premises database doesn't have the required SQL roles.

Resolution

Make sure that the SQL user that's specified in the self-hosted integration runtime connection string has the following roles on the on-premises database:

• sysadmin server-level role
• db_owner database role