This error usually occurs when the user has not been assigned the correct security permissions on the SQL database. User require:
Server Roles – dbcreator and public (for BACKUP and RESTORE)
User Mapping – dbowner and public
If you need further assistance, please raise a case online and reference the title of this article.