Step 3. Specify Target Server

In this article

    At this step of the wizard. specify the following:

    • A production SQL Server VM name and/or SQL Server instance to which you want to restore your database.

    Use the server_name\instance format. You can select a server or instance from the drop-down list or use the Browse button on the left, as described in Browsing for Servers.

    • The user account to connect to the target SQL Server.

    Select the Use SQL Server authentication check box to use SQL Server authentication. If not selected, Veeam will use Windows authentication.

    Make sure the account you are using has been granted the sysadmin role on a target SQL Server.

    Step 3. Specify Target Server Important

    Make sure that the administrative share (for example, \\myserver\C$) on a target machine is available. Read and Write are minimum required permissions, Full Control is recommended.

    Specify Target SQL Server

    When selecting the Use SQL Server authentication check box and providing your SQL Server account, you will be asked to provide a target production server account in the next step, as shown below.

    Step 3. Specify Target Server 

    Browsing for Servers

    To browse for a server, do the following:

    Browsing For Servers