Veeam Backup & Replication
Integrating Veeam Backup & Replication with vScope allows asset discovery via either SQL or API connections. This guide provides setup instructions and troubleshooting tips.
Notice: vScope does not currently support Veeam Backup & Replication on PostgreSQL databases.
Connecting to Veeam via SQL (Recommended)
The SQL method for connecting Veeam to vScope is straightforward, especially as Veeam is commonly bundled with SQL Server Express. This is the primary data source that vScope will target.
Adding a Credential for Veeam’s SQL Database
- In vScope, go to Discovery > Credential > Veeam (Admin permissions required).
- Username: Use the domain account or SQL Server login with sufficient read permissions for the database.
- Target: Enter the host machine for the SQL database.
- Port: If the SQL Browser service is enabled (default disabled for SQL Express), vScope will automatically detect the correct port. You can set a custom port under Advanced if necessary.
- Click Save.
Connecting to Veeam via API
Notice: API connections may provide broader data to vScope, but are currently under development by Veeam (as of October 2023). Further support for additional data sources will be added over time.
Requirements
- Veeam Backup & Replication version 12.0 or later (Non-community Edition)
Adding a Credential for Veeam’s API
- Go to Discovery > Credential > Veeam.
- Click on the text link “Having problems connecting to Veeam 12?” to switch to API credentials.
- Enter the appropriate Username and Password.
- Click Save.
Enable Running per-VM backup in Veeam
Running per-VM backup in Veeam will allow you to use vScope to merge a detailed server documentation with information about your backup routines - Everything in one place. This is relevant in use cases such as billing, tracing privacy data and optimizing backup jobs.
From Veeam Helpcenter
To create per-VM backup files, you must enable the Use per-VM backup files option at the level of the backup repository. It is recommended that you enable this option for deduplicating storage appliances that support multiple write streams. The option is also enabled for scale-out backup repositories by default.
Learn More
https://helpcenter.veeam.com/docs/backup/vsphere/per\_vm\_backup\_files.html?ver=95u4
Common Errors
If you experience issues connecting Veeam to vScope, here are some troubleshooting steps.
Enabling SQL Browser Service
One common issue is that the SQL Browser service is not enabled. Follow the steps in this article:
Discovery of SQL Express Instances on Dynamic Ports
Or refer to Microsoft Technet.
Configuring Port Access
Ensure the port used by the Veeam SQL instance is open. To check which port the instance listens on, use vScope’s table configuration:
Verifying Veeam SQL Connection Details
To confirm that vScope can connect to the Veeam SQL instance, follow these steps:
-
Locate the SQL Instance Name
- Open Registry Editor on the Veeam server and navigate to:
- The instance name (e.g.,
VEEAMSQL2012
) is shown here.
-
Verify TCP/IP is Enabled for SQL Instance
- Open SQL Server Configuration Manager on the Veeam server.
- Expand SQL Server Network Configuration > Protocols for [InstanceName].
- Ensure TCP/IP is enabled.
-
Enable Remote Connections for SQL Instance
- In SQL Server Configuration Manager, right-click TCP/IP under Protocols for
[InstanceName]
and select Properties. - Under the IP Addresses tab, find the IPAll section. Confirm that the port is specified in TCP Dynamic Ports (e.g., 49845).
- In SQL Server Configuration Manager, right-click TCP/IP under Protocols for
-
Ensure Firewall Access on SQL Port
- Open Windows Firewall with Advanced Security on the Veeam server.
- Add an inbound rule to allow the SQL port (e.g., 49845) using the following steps:
- Go to Inbound Rules > New Rule.
- Select Port > TCP > Specific Local Ports and enter the port number.
- Select Allow the connection and apply it to all profiles.
- Name the rule and click Finish.
Adding Veeam in Discovery Manager
Once everything is configured, add a Veeam credential in Discovery Manager. Under Advanced, you can set the preferred port for SQL connection.