Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Log & Event Manager (LEM) > Microsoft.SqlServer.Management.Trace.SqlTraceException: Failed to initialize object as reader

Microsoft.SqlServer.Management.Trace.SqlTraceException: Failed to initialize object as reader

Table of contents

Updated May 17, 2017

Overview

This article provides information on the following error in the Windows application event logs:

Thread ID: 01: InitializeAsReader Exception: Microsoft.SqlServer.Management.Trace.SqlTraceException: Failed to initialize object as reader. ---> System.Runtime.InteropServices.COMException
   at ?A0xc799a991.ProcessError(Int32 hr, UInt16* lpszMessage)
   at Microsoft.SqlServer.Management.Trace.CTraceControllerBase.InitSource(Boolean bReOpe

 

The MSSQL Auditor service is configured to run as a local system account and uses a different account to connect to the MSSQL database (all on the same machine). The events from the MSSQL Auditor do not display but the OS/Application events from the same machine are accessible. 

Environment

  • LEM 6.3.1
  • MSSQL Auditor
  • SQL Server 2014

Detail

The issue is caused when the user account running MSSQL Auditor service does not have Alter Trace permissions.

Take note of the following to avoid the issue:

  • Use localhost as the server name in the MSSQL Auditor configuration. Do NOT append a backslash followed by the default DB instance.
  • Use the local system account (NT AUTHORITY\SYSTEM) to run the Auditor service.
  • The NT AUTHORITY\SYSTEM must have Alter Trace permission granted in the SQL Server Management Studio.

 

Last modified

Tags

Classifications

Public