Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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: 82 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