Referencing our Documentation:
https://docs.automic.com/documentation/webhelp/english/AWA/12.0/DOCU/12.0/AWA%20Guides/help.htm#AE_AWA_Source/Installation/ucaakf.htm%3FTocPath%3DInstallation%2520Guide%7CInstalling%2520the%2520Automation%2520Engine%7CNew%2520Installation%7CInstallation%2520Procedure%7CSetting%2520up%2520the%2520Database%7CMS%2520SQL%2520Server%7C_____0
The following rights must be assigned:
Section 3. Creating a Database User
- Highlight the AE database in the Database access tab and select db_backupoperator, db_datareader, db_datawriter, db_ddladmin, db_owner and public in the database roles.
Once these permissions are in place, this error should no longer present during a correctly performed upgrade/Database Load.