Connection to Microsoft SQL Server

The account used to connect to the Microsoft SQL Server hosting the Veeam ONE database during installation must have the following permissions:

• Public role — default permissions for SQL users
• CREATE ANY DATABASE permissions — required for database creation during setup
• db_owner role on the Veeam ONE database — required for communication of Veeam ONE services with the database
• db_datareader permissions on the master database — required to verify that only one product installation writes data to the database
• public, db_datareader, SQLAgentUserRole permissions on the msdb database — required for setup and database index optimization
• [For Always-On Availability Groups] VIEW SERVER STATE, VIEW ANY DEFINITION permissions — required to check database existence and to verify that Veeam ONE will write data to the primary replica of the database

After installation, the account used for upgrades and communication of Veeam ONE services with Veeam ONE database must have the following permissions:

• Public role (default permissions)
• db_owner role on the Veeam ONE database
• db_datareader permissions on the master database
• [For Always-On Availability Groups] VIEW SERVER STATE, VIEW ANY DEFINITION permissions

• [Optional]* public, db_datareader, SQLAgentUserRole permissions on the msdb database

*Required for database index optimization. Using the account without these permissions may slow down database performance.

For details on permission requirements for SQL Server Reporting Services connection, see Configuring SSRS Server Settings.