Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

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: 65 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
14:15, 7 Sep 2017

Tags

Classifications

Public