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
-
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.
-