User guide

"Services and Applications" in the Computer Management Client. On the Security tab, ensure

that the SQL Sentry Monitoring Service account has at least "Enable Account" and "Remote

Enable" checked for the CIMV2 and WMI nodes.

NOTE: WMI providers and versions will vary from server to server, and whether or not non-

administrative access will function properly for a particular WMI provider is directly dependent on

whether or not the provider was designed to support this. Many providers simply are not, including

many designed by Microsoft.

Please consider the following example:

SERVER-A is the exact same make and model as SERVER-B, and both servers are on the same domain.

The SQL Sentry Monitoring Service user account is a Domain User, but does not have Administrator

privileges on either server. Performance Advisor can successfully watch SERVER-A, but is unable to

watch SERVER-B. The two servers are configured identically, with one exception -- an additional

network adapter from Acme Networking was installed in SERVER-B. Unfortunately, Acme Networking

didn't design the associated WMI provider to support non-administrative access, therefore

Performance Advisor will not be able to successfully watch SERVER-B as a non-Administrator. In this

scenario, the only options are to either replace the network adapter with one that is known to support

non-administrative access, or to contact Acme Networking to see if they have an updated version of

the provider that supports non-administrative access.

10.1.2 Performance Advisor Required Ports

In order for Performance Advisor to properly monitor a server on the network, the following ports on

the monitored server must be accessible to the SQL Sentry Server machine(s):

For SQL Server access:

tcp 1433 (or whatever port is used by SQL Server)

For Windows Performance Counter access:

tcp 445 (SMB, RPC/NP)

For WMI access:

tcp 135 (RPC)

-and-

one of these ranges:

tcp 49152-65535 (RPC dynamic ports -- Vista and Win2008)

-or-

tcp 1024-65535 (RPC dynamic ports -- NT4, Win2000, Win2003)

-or-

a custom RPC dynamic port range (see below)

The only one that may be tricky for firewalls are the RPC dynamic ports. WMI (or any other process

SQL Sentry Quick Start 35