Loading...

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:
    Expand All

    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 iDataAgent Configuration dialog box is displayed.

    To set the user account at the client computer group level:

    1. In 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. In 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. In 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:
    • 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.

      This option enables the user to perform SQL backup operations by using the permissions that are associated with the impersonated account, instead of the permissions that are associated with the user’s account.

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