Configuring Staging SQL Server

A staging Microsoft SQL Server is required in the following cases:

A machine used as a staging Microsoft SQL Server for the data export, data restore and data publishing operations can reside in the same domain as the machine hosting Veeam Explorer for Microsoft SQL Server, as well as in a trusted domain or untrusted domain.

For the add standalone database operation, consider the following:

  • A machine used as a staging SQL Server can reside in the same domain as the machine hosting Veeam Explorer for Microsoft SQL Server or in a trusted domain. You cannot use a staging server that belongs to an untrusted domain to add a standalone database to Veeam Explorer for Microsoft SQL Server.
  • Both Windows authentication and SQL Server authentication methods are supported for the staging SQL Server. If you want to use Windows authentication, complete the following steps to configure delegation settings:
  1. In Active Directory Users and Computers, select a staging SQL Server.
  2. Open server properties and go to the Delegation tab.
  3. Select the 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 SQL Server.
  4. Restart the staging SQL Server VM.
  5. Select a domain user account that you want to use when connecting to the staging SQL Server VM and make sure the Account is sensitive and cannot be delegated check box is not selected.

To configure a staging server, do the following:

  1. In the Veeam Explorer for Microsoft SQL Server main menu, click General Options.
  2. On the Staging Server tab, select the Use this helper SQL Server for advanced recovery functionality check box and do the following:
  1. From the SQL Server name drop-down list, select a server that you want to use as your staging SQL Server.

You can click Browse to locate a server using the built-in browser, as described in Browsing for Servers.

  1. In the Specify user account to connect to Windows server section, select the following:
  • Use current account. To connect to the specified server using the current user account under which Veeam Explorer for Microsoft SQL Server running.
  • Use the following account. To connect to the specified server under a custom user account.

When using a custom account, in the Username field, specify a user name and in the Password field, provide the password.

  1. In the Specify user account to connect to SQL Server instance section, select the following:
  • Use the Windows server account specified above. To connect to the specified instance under the user account that you have specified in the Specify user account to connect to Windows server section.
  • Use the following account. To connect to the specified instance under a custom user account.

When using a custom account, in the Username field, specify a user name and in the Password field, provide the password.

To use SQL Server authentication, select the Use SQL Server authentication check box.

Configuring Staging SQL Server

Browsing for Servers

To browse for a server, do either of the following:

Browsing For Servers