Veeam ONE Manual Database Creation

KB ID: 2312
Product: Veeam ONE | 7.0 | 8.0 | 9.0 | 9.5 | 10 | 11
Published: 2017-06-30
Last Modified: 2021-04-20
Get weekly article updates
By subscribing, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.

Cheers for trusting us with the spot in your mailbox!

Now you’re less likely to miss what’s been brewing in our knowledge base with this weekly digest

error icon

Oops! Something went wrong.

Please try again later.

Objective

This article documents how to manually create a new Veeam ONE database.

Solution

1. Open SQL Server Management studio.
2. Create a service account for Veeam ONE and assign the following permissions to it:
  • 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

NOTE: 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.
 

3. Create a new database using the account specified above.
4. Run the installation SQL script against the new database. The script can be found on the Veeam ONE ISO: Addins\SQLScript\VeeamOne.sql.
5. [For Always-On Availability Groups] Manually add the Veeam ONE database to the corresponding SQL AlwaysOn Availability Group (skip this step if you do not use SQL Server AlwaysON).
6. Install Veeam ONE using the specified Service Account and the database created earlier. If Veeam ONE is already installed, update the existing database server address (if needed) and the database name using the Veeam ONE Settings utility located in C:\Program Files\Common Files\Veeam ONE\Veeam One Settings\VeeamOneSettings.exe
7. Install Veeam Reporter packs. See this KB for details.
8. Install the latest Update for Veeam ONE (skip this step in case you completed this requirement during the Reports pack installation).
9. Update websites settings. See this KB article for details.

More information

NOTE: As Veeam ONE operates with the huge amount of data, the database size and the database transaction log growth could be high.

Should you have any questions, contact Veeam Support.
Send Article Feedback
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.

Spelling error in text

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

Oops! Something went wrong.

Please try again later.

KB Feedback/Suggestion

This form is only for KB Feedback/Suggestions, if you need help with the software open a support case

By submitting, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Verify your email to continue your product download
We've sent a verification code to:
  • Incorrect verification code. Please try again.
An email with a verification code was just sent to
Didn't receive the code? Click to resend in sec
Didn't receive the code? Click to resend
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

error icon

Oops! Something went wrong.

Please try again later.