Connection to Microsoft SQL Server

In this article

    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. 

    I want to report a typo

    There is a misspelling right here:

     

    I want to let the Veeam Documentation Team know about that.