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.
-
Set the user account based on the entity level:
To set the user account at the CommCell level:
-
On the CommCell Console ribbon, click the Home tab, and then click Control Panel.
-
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:
-
From the CommCell Browser, expand Client Computer Groups.
-
Right-click the client group, and then click Properties.
The Client Group dialog box is displayed.
-
On the Advanced Settings tab, select the Override Higher Levels Settings check box.
To set the user account at the agent level:
-
From the CommCell Browser, click Client Computers > client.
-
Right-click SQL Server, and then click Properties.
The SQL Server Properties dialog box is displayed.
-
On the SQL Agent Authentication tab, select the Override Higher Levels Settings check box.
To set the user account at the instance level:
-
From the CommCell Browser, click Client Computers > client > SQL Server.
-
Right-click instance, and then click Properties.
The Properties of SQL Server dialog box is displayed.
-
On the Accounts tab, select the Override Higher Levels Settings check box.
-
-
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.
-
-
Type the credentials for the user account you want to log on, and then click OK.