Complete the Guided Setup for SQL Server Database Running On-Premises

The databases guided setup guides you through creating a backup plan, adding a SQL database server, and creating credentials for SQL Server authentication.

Procedure

1. From the navigation pane, go to Guided setup.

   The Welcome page appears.

2. On the Protect tab, click Configure on the Databases tile.

   The Configure Database Server page appears.

3. Select Database running on-premises, and then select SQL server.

4. Click Next.

   The Plan page of guided setup appears.

5. If you already have a backup plan, select it. Otherwise, create a new backup plan.

6. Click Next.

   The Add database server page appears.

7. In the Host name box, using a comma separate list, enter a name for the database instance machines.

8. For OS Type, select the operating system of the database server.

9. For OS Type, select the operating system of the database server.

10. If you selected Windows, from the Credential list, select the credential.

11. If you selected the Unix operating system, do the following:

    1. From the Credential list, select the credential.

    2. In the UNIX group box, enter the name of the Unix group.

    3. In the SSH port number box, verify the port number.

    4. If you want to use SSH instead of user credentials, move the Use SSH key toggle to the right, and then in the SSH key path box, enter the file path.

    5. To use an SSH key file passphrase, move the Use SSH key file passphrase toggle key to the right, and the in the Passphrase box, enter the passphrase for the SSH key.

       Steps to add a credential

       1. Click +.

          The Add Credential dialog box appears.

       2. In the Credential name box, enter a unique name to access the credential.

       3. In the User account box, enter the user account that access to the SQL server.

       4. In the Password box, enter the password for the user account. For Unix, you can also enter a passphrase.

       5. In the Description box, enter a brief description for the credential.

       6. Click Save.

12. Click Save.

13. Click Next.

    The Credentials page appears.

14. Select an existing credential or create a new credential for SQL Server authentication.

    Steps to create a new credential

    1. Click +.

       The Add Credential dialog box appears.

    2. In the Credential name box, enter a unique name to access the credential.

    3. In the User account box, enter the user account that access to the SQL server.

    4. In the Password box, enter the password for the user account.

    5. In the Description box, enter a brief description for the credential.

    6. Click Save.

    Note

    • If you are installing the SQL Server on a Windows server, select the Windows account for SQL impersonation. A new credential is added as Windows account.

    • If you are installing the SQL Server on a Linux server, select the SQL account for SQL impersonation. A new credential is added as SQL account.

    • If a credential is not selected, the local system account will be used for impersonation. If a credential is selected, credentials for impersonation should be common between all selected servers. Once the installation is complete, credential will be available for modification at the server level.

    • If you have servers that are running on Windows and Linux, a common credential must not be used. Instead, leave the credential blank and set the impersonation on servers manually after the installation completed.

15. Click Next.

    The Summary page appears.

16. Review the summary, and then click Finish.