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:
- Copy the file(s) from another working MSSQL server installation of the same version.
- Place the file(s) in the folder mentioned above in your server that is having the issue.