You can use Microsoft SQL Server 2012 Express that is shipped with Veeam Backup & Replication as a staging system (a default staging server). You can also use another SQL Server instance, either local or remote, as a staging system.
To configure a staging server, do the following:
- Launch Veeam Explorer for Microsoft SQL Server, open the main menu and click Options.
- Select the necessary SQL Server instance (local or remote) from the list.
- Specify the user account that will be used to access the selected SQL server. This can be your current account (the one under which Veeam Explorer is running) or another one.
- Specify the account that will be used to access a Windows machine where SQL server is running.
If you plan to add database(s) to Veeam Explorer scope manually, as described later in this guide, consider the following when setting up the staging SQL Server:
- If this SQL Server belongs to an untrusted domain, connection will not be possible.
- If this SQL Server belongs to a trusted domain, then only SQL Server authentication is possible.
- If this SQL Server belongs to the same domain as the machine where Veeam Explorer runs, then both Windows and SQL Server authentication methods are possible. In this case, if you plan to use Windows authentication for connection, you will need to configure delegation settings as follows:
- In Active Directory Users and Computers, select the necessary staging SQL Server.
- Open server properties and select the Delegation tab. Select Trust this computer for delegation to specified services only and Use any authentication protocol options for the cifs service on the computer where Veeam Explorer runs.
- After that, restart the staging SQL Server.
- Select the domain user account that you want to use for connection to the staging SQL Server, and in its properties on the Account tab make sure the Account is sensitive and cannot be delegated check box is cleared.