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