Configuring User Accounts for the SQL Server Agent

You can configure the user accounts at an entity level by logging into the correct user account level on a SQL Server. For more information on user account levels, see User Accounts Required by the SQL Server Agent.

  1. Set the user account based on the entity level:

    To set the user account at the CommCell level:
    1. On the CommCell Console ribbon, click the Home tab, and then click Control Panel.

    2. In the User pane, click SQL iDataAgent.

      The SQL Agent Configuration dialog box appears.

    To set the user account at the client computer group level:
    1. From the CommCell Browser, expand Client Computer Groups.

    2. Right-click the client group, and then click Properties.

      The Client Group dialog box is displayed.

    3. On the Advanced Settings tab, select the Override Higher Levels Settings check box.

    To set the user account at the agent level:
    1. From the CommCell Browser, click Client Computers > client.

    2. Right-click SQL Server, and then click Properties.

      The SQL Server Properties dialog box is displayed.

    3. On the SQL Agent Authentication tab, select the Override Higher Levels Settings check box.

    To set the user account at the instance level:
    1. From the CommCell Browser, click Client Computers > client > SQL Server.

    2. Right-click instance, and then click Properties.

      The Properties of SQL Server dialog box is displayed.

    3. On the Accounts tab, select the Override Higher Levels Settings check box.

  2. Select any one of the following accounts to log on:

    Windows Configuration

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

    • Impersonate User: To use a specific SQL account, select this option, and from the Credential list, select the credential for the SQL server account.

    Linux Configuration

    • Impersonate User: To use a specific SQL account, select this option, and from the Credential list, select the credential for the SQL server account.

      The user must be a SQL server authenticated user with sysadmin access.

      Tip

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

Loading...