Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Log & Event Manager (LEM) > MSSQL Auditor error: Verify that the user has the proper credentials to do database auditing

MSSQL Auditor error: Verify that the user has the proper credentials to do database auditing

Created by Craig O’ Neill, last modified by Tim Rush on Sep 07, 2017

Views: 1,097 Votes: 1 Revisions: 5

Overview

The MSSQL Auditor does not start and displays the following error:

Unable to start MSSQLAuditor. Verify that the user has the proper credentials to do database auditing by using the Auditorconfig Test button.

 

This is the "test" button for the MSSQL Auditor application.

 

 

To avoid the error, be sure the account has the permissions to access the SQL database, and the logon-as-a-service right. The default SYSTEM account will have the "logon-as-a-service right", but may lack the permission to access the SQL database. You can create a new SA account (local or domain level) to access the database, but be sure to give the account the "logon-as-a-service right".

Environment

All LEM versions

Cause 

This is a Windows permissions (& rights) issue.

Resolution

Verify that the user account has been granted the Logon as a service right on the server where MSSQL Auditor is installed. Refer to Add the Logon as a service right to an account.

 

 

Last modified

Tags

Classifications

Public