Help Center
Choose product document...
Veeam Backup & Replication 9.5 Update 4
Veeam Explorers User Guide

Configuring Staging SQL Server

A staging SQL server is required in the following cases:

  • When exporting data.
  • When using the fine-tune feature.

For more information about requirements for a staging server, see Staging SQL Server Requirements

Consider the following:

  • You cannot access a staging server that belongs to an untrusted domain.
  • If a staging SQL server belongs to a trusted domain, only the SQL server authentication method is possible.
  • If both a staging SQL server and machine hosting Veeam Explorer belong to the same domain, then both Windows and SQL Server authentication methods are possible.

To use Windows authentication, make sure to configure delegation settings as follows:

  1. In Active Directory Users and Computers, select a staging SQL Server.
  2. Open server's properties and go to the Delegation tab.
  3. 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.
  4. Restart the staging SQL server.
  5. Select a domain user account you want to use when connecting to the staging SQL server, open its properties, go to the Account tab and make sure the Account is sensitive and cannot be delegated checkbox is not selected.

To configure a staging server, do the following:

  1. Go to the main menu and click General Options.
  2. Go to the SQL Server Settings tab.
  3. Specify a SQL server you want to use as a staging system.

Click Browse to select a server, as described in Browsing For Servers.

  1. Specify the account to access the selected server.
  2. Specify the account to access a SQL server instance.

Configuring Staging SQL Server

Browsing for Servers

To browse for a server, do the following:

Browsing For Servers

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Agent Management Guide

Veeam Explorers User Guide

Backup and Restore of SQL Server Databases

Veeam Plug-ins for Enterprise Applications

PowerShell Reference

Veeam Explorers PowerShell Reference

RESTful API Reference

Required Permissions

Veeam Availability for Nutanix AHV

Veeam Backup for Microsoft Office 365 Documentation

Veeam ONE Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation