Return
-
Title
SQL Error - "The EXECUTE permission was denied on the object..." -
Description
A SQL Error may appear suddenly if the service account used by the Migration Manager Console has roles removed.
-
Cause
Role permissions were removed from the service account used by Migration Manager for SQL access. -
Resolution
Ensure the "DB_Creator" role is added through the "SQL Studio Management" for the Migration Manager service account. i.e. The account used to launch Migration Manager.