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 Command Center navigation pane, go to Service catalog.

    The Welcome page appears.

  2. Click Configure on the Databases tile.

    The Configure Database Server page appears.

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

    The page to add a database server appears.

  4. Install the database server package using either the Interactive installation or Push installation method:

    • To install software interactively on database servers, select Interactive installation and then complete the following steps:

      1. Download and install the database server package on the database servers to be protected.

      2. Return to this window after the agent installation has completed.

      3. From the Server name list, select the newly installed servers.

    • To install client software on database servers using the push method, select Push installation and then complete the following steps:

      1. Click Add.

        The Add database server dialog box appears.

      2. In the Host name box, enter the host name of the database.

      3. Select the OS type:

        • Windows:

          1. To select a software cache from which to push agent packages, from the Software cache list select a server.

            The software cache works as a network gateway between the server and client.

          2. To use saved credentials, move the Use saved credentials toggle key to the right.

            From the Credential list, you can select a saved credential or add a new credential.

            Steps to add a new credential
            1. Click +.

              The Add credential dialog box appears.

            2. From the Credential Vault list, select a credential vault to store, share, and update account credentials with shared resources in your environment.

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

            4. In the User account box, enter the user account that has access to the database server.

            5. In the Password/Passphrase box, enter the password for the user account.

            6. Click Save.

          3. If you are not using saved credentials, move the Use saved credentials toggle key to the left and enter the user name and password.

        • Unix and Linux:

          1. To select a software cache from which to push agent packages, from the Software cache list select a server.

            The software cache works as a network gateway between the server and client.

          2. To use saved credentials, move the Use saved credentials toggle key to the right.

            From the Credential list, you can select a saved credential or add a new credential.

            Steps to add a new credential
            1. Click +.

              The Add credential dialog box appears.

            2. From the Credential Vault list, select a credential vault to store, share, and update account credentials with shared resources in your environment.

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

            4. In the User account box, enter the user account that has access to the database server.

            5. To use an SSH key for a UNIX or Linux server, move the Use SSH key toggle to the right and then enter the SSH key path.

            6. In the Password/Passphrase box, enter the password for the user account.

            7. Click Save.

          3. If you are not using saved credentials, move the Use saved credentials toggle key to the left and enter the user name and password.

          4. Enter the SSH port number.

          5. To use an SSH key, move the Use SSH key toggle to the right and then enter the SSH key path.

          6. To grant write access to processes that belong to a specific group, enter the UNIX group name.

      4. To specify the installation location, in the Installation location box enter the path on the server.

      5. You can configure the following options during installation by moving the corresponding toggle keys to the right:

        • Install MediaAgent

        • Restore only agent

        • Reboot if required

      6. Click Install.

      7. When the install jobs are complete, from the Server name list, select the newly installed servers.

  5. Click Next.

    The Select A Plan dialog box appears.

  6. From the backup plan list, select the backup plan to use.

    The backup plan defines how often the software backs up the database and the log files, and where it stores the backups.

  7. Click Next.

    The Credentials page appears.

  8. Select an existing credential, create a new credential for SQL Server authentication, or move the Use local system account toggle to the right to use a local system account.

    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 a 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 the 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, the credential will be available for modification at the server level.

    • If you have servers that are running on both 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.

  9. Click Next.

    The Summary page appears.

  10. Review the summary and click Finish to add the database server.

×

Loading...