The Veeam credential is used by vScope to discover your Veeam installation. vScope utilizes the SQL server required by Veeam for information gathering. By default, Veeam comes bundled with SQL Server Express so this database instance is the target for vScope.
The Veeam credential can be added in Discovery Manager as any other credential.
Required. Use the domain account or SQL server login used to access the database. This should have been specified during the Veeam setup. If in doubt, attempt to use a service account with sufficient rights.
Required. The password used in conjunction with your username to log into Veeam server. Should not be left empty.
The port for the Veeam SQL instance. For information on how to find which port the instance is listening on and assert that the port is accessible from a remote computer, follow the guide below.
Locate connection details
In order to make sure that vScope is able to connect to the Veeam SQL instance we need to follow some steps:
- Find out the name of the Veeam SQL instance
- Assert that the Veeam SQL instance is listening on TCP/IP
- Assert that the Veeam SQL instance is accepting remote connections
- Assert that the firewall allows remote connections on the SQL instance port
Find out the name of the Veeam SQL instance
Open regedit on the Veeam server and find the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\Veeam Backup and Replication\SqlInstanceName
In this case, our instance name is VEEAMSQL2012.
Assert that the Veeam SQL Instance is listening on TCP/IP
Open the SQL Server Configuration Manager on the Veeam Server. Expand SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for VEEAMSQL2012. Make sure that TCP/IP is enabled. If it is not, right click and choose Enable.
Assert that the Veeam SQL instance is listening for remote connections
Open the SQL Server Configuration Manager on the Veeam Server. Expand SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for VEEAMSQL2012 and then right click TCP/IP and select Properties.
Select the IP Addresses tab and scroll down to the IPAll section. The value for TCP Dynamic Ports is the port that the VEEAMSQL2012 instance is listening on. In our case this is 49845.
IPAll means that port 49845 is listening on all interfaces which is needed to access the SQL instance from a remote machine. Make sure the port is not set to 0 which means that the can change every time the SQL instance is restarted.
Assert that the firewall allows remote connections on the SQL instance port
The port we found earlier (49845) must be opened in the firewall on the machine running the Veeam SQL instance.
Open Windows Firewall with Advanced Security on the Veeam server.
- Right click Inbound Rules and select New Rule.
- Select Port and click Next.
- Select TCP and Specific local ports. Enter the port here (in our case 49845).
- Click Next
- Select Allow the connection. Click Next.
- Select which network profiles the rule should apply on. I suggest you select Private, Domain and Public. Click Next.
- Select a name for the new rule and click Finish.
The rule should now appear in the list of rules.
If you have any other firewall in the path between vScope and the Veeam SQL instance, make sure that the same port it not blocked.