Appendix C. Creating Veeam ONE Database with a SQL Script
In some circumstances, it might be undesired to create the Veeam ONE database automatically, using the Veeam ONE Setup wizard. For example, Veeam ONE components and the Microsoft SQL Server can be hosted on different systems, and you do not have sufficient permissions on the Microsoft SQL Server to create the database. In this case, you can use a SQL script to create the Veeam ONE database on a Microsoft SQL Server. The script is included with the Veeam ONE installation image.
To create the Veeam ONE database with the SQL script, perform the steps described below. Note that the database must be created before you start installation of Veeam ONE components.
Step 1. Locate the SQL Script
Download the Veeam ONE installation image and burn it to a blank CD/DVD or mount the image using disk image emulation software. If you are working with a virtual machine, use built-in tools of the virtualization management software to mount the installation image to the virtual machine.
In Windows Explorer, right-click the drive with the image, select Open and go to the <CD Drive>\Addins\SQLScript directory. Copy the VeeamONE.sql file to the location from which it can be accessed or run.
Step 2. Create the Veeam ONE Database
Connect to the necessary Microsoft SQL Server with Microsoft SQL Server Management Studio and create a new database (for example, VeeamOne).
Step 3. Run the SQL Script Against the Veeam ONE Database
Execute the VeeamONE.sql script against the Veeam ONE database in Microsoft SQL Server Management Studio.
Alternatively, you can execute the script using the sqlcmd utility. In the command prompt, run the command of the following form:
sqlcmd -S localhost\VEEAMSQL2012 -d VeeamOne -E -i "E:\Addins\SQLScript\VeeamOne.sql"
The following command-line options are used to run the script:
Specifies the SQL Server instance to which sqlcmd connects.
Specifies the name of the database against which the script is executed.
Instructs sqlcmd to connect to the SQL Server Database Engine using Windows Integrated Security.
Specifies the full path to the script file for execution.
Step 4. Grant Database Permissions
Create a Microsoft SQL Server account with permissions described in section Connection to Microsoft SQL Server of the Veeam ONE Deployment Guide.
Step 5. Perform Post-Installation Configuration Steps
After you install Veeam ONE, perform additional configuration steps:
- Launch Microsoft SQL Server Management Studio, and connect to the Microsoft SQL Server that hosts the Veeam ONE database.
- In the Object Explorer pane, navigate to Databases.
- Right-click the Veeam ONE database and choose to run a new query.
- Execute stored procedure to set the Veeam ONE Reporter URLs.
To set the Veeam ONE Reporter URL, run the following query:
exec common.SetSetupDataReporterURI 'https://REPORTERFQDN:1239/'
where, REPORTERFQDN stands for the FQDN of the machine that runs the Veeam ONE Web UI component, and default port is used to connect to Veeam ONE Reporter.
- Execute a stored procedure to set the Microsoft Windows version:
exec common.SetSetupDataWindowsVersion '%WINVERSION%'
where %WINVERSION% stands for the Windows OS version on the machine that runs the Veeam ONE Server component. The version number must be specified in the following format: 10.0.0.1. You can check the Windows OS version, by running the ver command in the command prompt.
- Close the Microsoft SQL Server Management Studio.