"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: