4 Configuring Connections

This chapter provides details about configuring connections for monitoring targets and executing jobs.

The following topics are provided:

4.1 Configuring Remote Connections to Monitor Targets

If you want to monitor targets using remote Agents, then Oracle recommends that you do the following security configurations on every system where SQL Server target resides.

  1. Set WMI namespace security.

  2. Restrict access to the registry from a remote computer.

  3. Set DCOM Security to allow user to access remotely.

  4. Set privileges for System User to access Windows performance counters remotely as follows:

    1. Locally on the Microsoft Windows node hosting the Agent, open the Local Security Settings Windows Tool. Go to Start, select Control Panel, and then select Administrative Tools, select Computer Management, select System Tools, then Local Users and Groups, and select Groups.)

    2. Add System Username to Performance Monitor Group as shown in Figure 4-1:

      Figure 4-1 Performance Group

      Surrounding text describes Figure 4-1 .

  5. Set access privileges of SQL Server Services to allow user to access a computer remotely.

  6. Set privileges for System User of target on Oracle Management Agent for Windows Integrated Authentication based monitoring.

    1. Locally on the Microsoft Windows node hosting the Agent, open the Local Security Settings Windows Tool. Go to Start, select Control Panel, and then select Administrative Tools, and select Local Security Policy.

    2. Click on Local Policies and then User Rights Assignment.

    3. Assign the following right to the System User of the target:

      Logon as batch job

  7. Configure Allow Remote Administration Exception in Windows Firewall if Windows firewall is enabled on the SQL Server target system.

  8. When using WIA remotely, the OMA host must be a member of the same Windows Domain.

4.2 Configuring Connections to Execute Jobs

If you want to execute jobs using local or remote Agents, then Oracle recommends that you do the following security configurations on every system where SQL Server target resides.

  • Set WMI namespace security.

  • Set DCOM Security to allow user to access a computer remotely.

For configuration details, refer to the following: