Step 4. Specify Target SQL Server Settings

At this step of the wizard. specify the following:

• A production SQL server 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 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.

• Click Browse to select a database to which you want to restore schema.

Browsing for Servers

To browse for a server, do the following:

• On the Local Servers tab, select a local SQL server that is located on a machine with Veeam Explorer.
• On the Network Server tab, select a SQL server over the network.