---
title: "Connection to Microsoft SQL Server"
description: "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..."
canonical: "https://helpcenter.veeam.com/docs/one/userguide/connection_to_sql.html"
breadcrumb: "User Guide > Deployment Planning and Preparation > Permissions > Connection to Microsoft SQL Server"
dateModified: "2026-10-23"
---

# 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

For details on permission requirements for SQL Server Reporting Services connection, see [Configuring SSRS Server Settings](configure_ssrs_server_settings.md).