Phone Lines icon GFI Support

Articles in this section

See more

Error: 'Unable to locate trace definition file for Microsoft SQL Server version <number>' When Auditing MSSQL

Author: Luis Fernandes Updated

Overview

Trying to audit a Microsoft SQL (MSSQL) server fails with the error:

Unable to locate trace definition file for Microsoft SQL Server version 10.50.0.

Note: The version number refers to the MSSQL version being used and can differ.

This article provides the resolution to fix the issue described above.

Environment

  • EventsManager
  • Any Supported Environment

Root Cause

The MSSQL component installation on the EventsManager server is missing trace definition files.

Resolution

Ensure that the MSSQL component installation on the EventsManager server is complete and contains the trace definition files. These files must be present in the folder specified below (depending on the Operating System) in the EventsManager server:

  • For 32-bit OS:
    c:\Program Files\Microsoft SQL Server\90\Tools\Profiler\TraceDefinitions
  • For 64-bit OS:
    c:\Program Files (x86)\Microsoft SQL Server\90\Tools\Profiler\TraceDefinitions

In the example given above, the file Microsoft SQL Server TraceDefinition 10.50.0.xml is missing. If the file(s) with the referenced version number is missing, do the following:

  1. Copy the file(s) from another working MSSQL server installation of the same version.
  2. Place the file(s) in the folder mentioned above in your server that is having the issue.