Veeam ONE New DB creation

KB ID: 2312
Product: Veeam ONE
Version: 7.x, 8.x, 9.x, 9.5
Published:
Last Modified: 2017-06-30

Challenge

Manual creation of the DB may sometimes be needed in specific environments

Solution

  1. Create Veeam ONE service account and assign in the following SQL 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.
Note : If the Veeam ONE database runs on a remote Microsoft SQL Server instance, with the Microsoft SQL Server and Veeam ONE components residing in the same workgroup, Microsoft SQL Server authentication will be required.
  1. Create a new DB using the Veeam ONE service account that has the permissions specified above assigned.
  2. Run Script from Veeam ONE ISO – Addons\SQLScript\SQLScript.sql
  3. Install VeeamONE using the specified Service Account and DB. If Veeam ONE is already installed Specify DB using Veeam ONE settings utility located in C:\Program Files\Veeam ONE\Veeam One  Settings\VeeamOneSettings.exe
Start Veeam ONE
 

More Information

Please note that build number must match installed version, Additionally Manual Import of Reporter packs will be needed for reporter to operate.
0 / 5 (0 votes cast)

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.

Request new content

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