Configuring Staging SQL Server Settings

To perform Microsoft SharePoint item recovery,  Veeam Explorer requires a Microsoft SQL Server that will be used as a staging system. You can use Veeam Explorer options to specify Microsoft SQL Server instance (local or remote) for that purpose. Do the following:

1. In the Options dialog, open the SQL Server Settings tab.
2. In the Use the following SQL server field, specify the SQL server instance that will be used as a staging system. You can click the Browse button to locate the necessary server instance among local or network servers.

3. Specify user account that will be used to access the staging SQL server - this can be current account (the one under which Veeam Explorer is running) or another account.
4. Specify account that will be used to access Windows machine where this SQL server runs. You can also use current account or another account.

If you plan to add content database(s) to Veeam Explorer scope manually, consider the following when setting up the staging SQL Server:

• If SQL Server belongs to an untrusted domain, connection will not be possible.
• If SQL Server belongs to a trusted domain, then only SQL Server authentication is possible.
• If 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:

1. In Active Directory Users and Computers, select the necessary staging SQL Server.
2. 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 the computer where Veeam Explorer runs.
3. After that, restart the staging SQL Server.
4. 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.