4 Configuring Connections
This chapter provides details about configuring connections for monitoring targets and executing jobs.
The following topics are provided:
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.
- Set WMI namespace security.
- Restrict access to the registry from a remote computer.
- Set DCOM Security to allow user to access remotely.
- Set privileges for System User to access Windows performance counters remotely as follows:
- Set access privileges of SQL Server Services to allow user to access a computer remotely.
- Set privileges for System User of target on Oracle Management Agent for Windows Integrated Authentication based monitoring.
- Configure Allow Remote Administration Exception in Windows Firewall if Windows firewall is enabled on the SQL Server target system.
- When using WIA remotely, the OMA host must be a member of the same Windows Domain.
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:
-
Microsoft Help and Support web site:
http://support.microsoft.com
-
How To Troubleshoot Microsoft SQL Server Plug-In Issues (Document 367797.1) on My Oracle Support:
https://support.oracle.com/rs?type=doc&id=367797.1