AuditViewer.exe fails to connect to the SQL server with Error querying database.

book

Article ID: 100047069

calendar_today

Updated On:

Description

Error Message

The following errors may occur after opening AuditViewer.exe. 

Error querying database.

SSL Security error
ConnectionOpen(SECCreateCredentials()).

SSL Security error

Error querying database.

SSL Security error
ConnectionOpen(SECDoClientHandshake()).

Error 2

Cause

This issue is caused by having TLS 1.0 > Client disabled on the EV server.  

Resolution

This issue has been addressed in the following versions available from Downloads:

Enterprise Vault 12.5.3

Enterprise Vault 14.0.1

Enterprise Vault 14.1.0  

Warning: Incorrect use of the Windows registry editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making any registry changes.

As a workaround the following can be enabled on the EV server and should allow the connection to succeed.  

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client]
"Enabled"=dword:00000001
"DisabledByDefault"=dword:00000000

The SQL server will need to allow TLS 1.0 connections as well.  The registry path for the SQL server is:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Server]
"Enabled"=dword:00000001
"DisabledByDefault"=dword:00000000

Additionally, the following document contains information on how to query the EnterpriseVaultAudit database within SQL for information. 

 

Issue/Introduction

This issue occurs when attempting to open AuditViewer.exe to view the Enterprise Vault (EV) Audit database entries.

Additional Information

JIRA: CFT-2491