Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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