Staging SQL Server

To perform Microsoft SharePoint items restore, Veeam Explorer for Microsoft SharePoint requires a Microsoft SQL server to be used as a staging system.

Note

Configuring the staging SQL server settings is only required to restore SharePoint data from the following sources:

  • Backups created by Veeam Backup & Replication.
  • Microsoft SharePoint databases manually added to the application scope. For more information, see Adding Microsoft SharePoint Databases.

Consider the following when configuring a staging SQL server:

  • If the SQL server belongs to an untrusted domain, connection will not be possible.
  • If the SQL server belongs to a trusted domain, only the SQL Server authentication method is available.
  • If both the SQL server and the machine running Veeam Explorer for Microsoft SharePoint belong to the same domain, then both Windows and SQL Server authentication methods are possible.

To use Windows authentication, make sure to configure the following delegation settings:

  1. In Active Directory Users and Computers, select the necessary staging SQL server.
  2. Open the 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 a computer with Veeam Explorer for Microsoft SharePoint.
  3. Restart the staging SQL Server.
  4. 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 a staging server, do the following:

  1. In the main menu, click General Options.
  2. Open the Staging Server tab.
  3. Click Browse to specify a SQL server that you want to use as a staging system. Do one of the following:
  • On the Local Servers tab, select a local SQL server that is located on a machine with Veeam Explorer for Microsoft SharePoint.
  • On the Network Server tab, select a SQL server over the network.
  1. Specify the account to access the selected SQL server.
  2. Specify the account to access a SQL server instance.
  3. Click OK.

Configuring Staging SQL Server