https://login.veeam.com/en/oauth?client_id=nXojRrypJ8&redirect_uri=https%3A%2F%2Fwww.veeam.com%2Fservices%2Fauthentication%2Fredirect_url&response_type=code&scope=profile&state=eyJmaW5hbFJlZGlyZWN0TG9jYXRpb24iOiJodHRwczovL3d3dy52ZWVhbS5jb20va2IyMzEyIiwiaGFzaCI6ImEzMGI3ZDI5LTIyODktNGI5Ni04NjEyLTIyMzQ0MmU2MjQ2NCJ9
1-800-691-1991 | 9am - 8pm ET
EN

Veeam ONE Manual Database Creation

Challenge

Manual creation of Veeam ONE database may be needed in some scenarios

Cause

Here is how Veeam ONE database can be created.

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\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.
KB ID:
2312
Product:
Veeam ONE
Version:
7.x, 8.x, 9.x
Published:
2017-06-30
Last Modified:
2020-08-13
Please rate how helpful this article was to you:
5 out of 5 based on 1 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.
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!

Spelling error in text

Knowledge base content request
By submitting, you agree that your personal data will be managed by Veeam in accordance with the Privacy Policy.
Your report was sent to the responsible team. Our representative will contact you by email you provided.
We're working on it please try again later