Info à .Database.ScriptAlter(StringCollection alterQuery, ScriptingPreferences sp) Info à .Database.IsDatabaseEncryptionKeyPresent() Info An exception occurred while executing a Transact-SQL statement or batch. Info à .Database.Alter(TerminationClause terminationClause) Alternatively, you can assign db_owner role for this database to the service account.Ĭode: Select all Info Alter failed for Database 'VeeamBackup'. The account used to run Veeam Backup Service requires db_datareader and db_datawriter roles as well as permissions to execute stored procedures for the configuration database on the Microsoft SQL Server. Not concinved from Veeam Support.Īccording this sysadmin rights are not neccessary.
#VEEAM BACKUP SERVICE NOT STARTING UPGRADE#
Maybe after Upgrade 2 some operations needed to take place and more permissions were neccessary for a short time. I removed the sysadmin rights again because it does not comply with our regulations, and restarted the Veeam Server and the service is running. He told me that it is neccessary that this user has sysadmin rights on the sql instance and did not explain anything further. I asked the Support if this is neccessary and explained that SQL sysadmin rights were not neccessary since Veeam v6, and that the user just has db_owner permissions on the db. He did not even asked me if he could give the user sysadmin rights. Veeam Support gave me a call half an hour after the appointment and gave the User for "Veeam Backup Service" sysadmin rights on the SQL Server instance.