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

    • If you want to use the administrator account of the computer that has the required privileges, select Use Local System Account.

    • If you want to use the permissions of another account that has the required privileges, select Impersonate User.

    Linux Configuration

    • Select Impersonate User.

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

  3. Type the credentials for the user account you want to log on, and then click OK.

Loading...