To be able to work with backups created with Veeam Backup & Replication, Veeam Explorer requires a staging SQL server configured up front.
To restore backups created with Veeam Backup for Microsoft Office 365, no staging SQL server is required.
Consider the following when configuring a staging SQL server:
- If a SQL server belongs to an untrusted domain, connection will not be possible.
- If a SQL server belongs to a trusted domain, only SQL Server authentication method will be available.
- If a SQL server belongs to the same domain as the machine where Veeam Explorer is running, then both Windows and SQL Server authentication methods are available.
In this case, if you plan to use Windows authentication, you will need to configure the delegation settings:
- In Active Directory Users and Computers, select the necessary staging SQL server.
- Open its 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 a computer with Veeam Explorer.
- Restart the staging SQL Server.
- Select a user account to connect to the staging SQL Server. Also, select its properties on the Account tab and make sure the Account is sensitive and cannot be delegated check box is cleared.
To configure SQL server settings, do the following:
- Go to the main menu and click the General Options.
- On the SQL Server settings tab, specify the following:
- The SQL Server name. You can click Browse and select either Local or Network server.
- Specify the user account to connect to the SQL server. When configuring local staging server, you can use your current account or specify another one. When configuring a remote staging server, only the Use the following account option will be available.