Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Log & Event Manager (LEM) > LEM - Knowledgebase Articles > 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