Manually Discovering SQL Instances

Updated

Although Commvault supports automatic discovery of new instances added to the SQL Server, you can also discover new instances on demand.

Procedure

  1. From the CommCell Browser, click Client Computers > client.

  2. Right-click SQL Server, point to All Tasks, and then click New SQL Server.

    The Properties of SQL Server dialog box appears.

  3. From the Instance Name list, select the instance that you want to assign to this SQL Server.

  4. To run backups or restores using a specific account, configure the user account at the instance level:

    1. On the Accounts tab, select the Override Higher Level Settings check box.

    2. Do one of the following:

      • Use Local System Account: To use the local system account, select this option.

      • Impersonate User: To use a specific account, select this option, and from the Credential list, select the credential for the SQL server. The list of credentials will be filtered according to OS and type of SQL server.

        • SQL on Windows: You will be able to use a Windows account
        • SQL on Linux: You will be able to use a SQL Server account

        Tip

        To add a new credential, from the Credential list, click Create New.

      For more information about the user account requirements, see Configuring User Accounts for the SQL Server Agent.

  5. Click OK.

Enabling Automatic Discovery of SQL Instances