Update to 9.5 Failing/Unable to connect to Veeam ONE DB

KB ID: 2265
Products: Veeam ONE
Version: 9.5
Published:
Last Modified: 2017-04-10

Challenge

During upgrade to 9.5 or installation of update ONE installer is unable to see DB

Cause

Lack of appropriate permissions on Veeam ONE DB

Solution

Ensure account being used as Veeam ONE service account has the following permissions.
The account used to connect to the Microsoft SQL Server hosting the Veeam ONE database must have the following permissions:

  • Public role (default permissions)
  • CREATE ANY DATABASE permissions
  • db_owner role on the Veeam ONE database
  • db_datareader permissions on the master database
  • publicdb_datareaderSQLAgentUserRole permissions on the msdb database
  • [For Always-On Availability Groups] VIEW SERVER STATE permissions
The Named Pipes protocol on the Microsoft SQL Server must be enabled.
 

More Information

If issue persists, contact Veeam for further Technical assistance.
0 / 5 (0 votes cast)

Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Orphus system