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

Configuring Staging SQL Server

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:

  1. Launch Veeam Explorer for Microsoft SQL Server, open the main menu and click Options.
  2. Select the necessary SQL Server instance (local or remote) from the list.
  1. 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.
  2. Specify the account that will be used to access a Windows machine where SQL server is running.

Configuring Staging SQL Server 

Configuring Staging SQL Server Important!

  1. Make sure the staging system meets the following requirements.
  2. Make sure the accounts you specify have sufficient permissions to connect to Windows machine and to access SQL server.
  3. Consider that specific ports on staging server will be used during the restore session.

Staging Server and Domain Trusts

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:

  1. In Active Directory Users and Computers, select the necessary staging SQL Server.
  2. 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.
  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.
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 Backup Explorers User Guide

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide

Veeam Backup for Microsoft Office 365

Veeam ONE Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation