Configuring Staging SQL Server

In this article

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

    A machine used as a staging SQL Server for the data export, data restore and data publishing operations can reside in the same domain as the machine hosting Veeam Explorer, 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 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.
    • 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.
    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. Go to the main menu and click General Options.
    2. Go to the Staging Server tab, select the Use this helper SQL Server for advanced recovery functionality check box and do the following:
    1. In 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. Under 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. Under 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 under 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 the following:

    Browsing For Servers