Phone Lines icon GFI Support

Articles in this section

See more

Unable to Gather Events from SQL Server 2016

Author: Luis Fernandes Updated

Overview

Unable to gather events from SQL Server 2016 showing an error message: Failed to initialize object as reader.

Environment

GFI EventsManager 13

Root Cause

The required profiler trace definitions are not present on the GFI EventsManager server and/or access is denied to collect events.

Resolution

To collect event logs from SQL Server 2016, ensure to have the following pre-conditions in place:

  • Install SQL Server Management Studio 17.4 on the SQL Server.
  • Enable Named Pipes option under SQL Server Configuration Manager for the SQL Server instance.
  • Enable Both failed and successful logins option under SQL Server Management Studio > Instance Properties.
  • Ensure that the SQL "sa" account is not locked under SQL Server Management Studio > Security > Logins.
  • Ensure the SQL "sa" account is specified under GFI EventsManager > Configuration > Event Sources > Select SQL Server > Properties > Connection Settings.

Follow these steps to transfer the trace definitions files:

  1. Copy trace definitions from the following path located on SQL Server Management Studio 17.4 (SQL Server 2016):

    C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Profiler\TraceDefinitions\

  2. Paste trace definitions on GFI EventsManager server in the following path:

    C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Profiler\ TraceDefinitions\

  3. Restart the SQL Server service.

  4. Restart GFI Database service, GFI EventsManager Monitor and GFI EventsManager service.