Answer
This depends on the setup of the SQL server. EventsManger can handle certain configurations, but not all.
During the installation of a MS SQL server one needs to chose between two different instance types. Each can be configured to use a static and/or a dynamic TCP port. These are the defaults:
- Default Instance - uses the static port 1433
- Named Instance - uses a dynamic port
EventsManager can NOT audit the following setups:
- Default Instance - on a non-default port (other than 1433)
- Default Instance - on a dynamic port
EventsManager can audit the following setups:
- Default Instance - on the static default port 1433
- Namend Instance - on a dynamic port
- Namend Instance - on a static port
NOTE: When using Named Instances ensure the following:
- The SQL Browser service is running on the SQL server
- UDP port 1434 is reachable on the SQL server
- The port on which the SQL instance is running itself
Background:
The SQL Browser service is being used to advertise how to connect to named instances, but it is never used for the default instance as of http://support.microsoft.com/kb/823938.