Error Message

Error:  “Access denied” on usage.asp reports.

Workaround

Edit the connection string in the Usage.asp and ListVaults.asp to use the MSOLEDBSQL provider while connecting to EV database. 

Steps:

1. Stop Enterprise Vault Services.
2. Take a backup of Usage.asp and ListVaults.asp file located at Install_Path\Program Files (x86)\Enterprise Vault\WebApp.
3. Edit both files in notepad and find and replace with below content.

Find all : 
pConnection.ConnectionString = "Driver={SQL Server}

Replace with: 
pConnection.ConnectionString = "Provider=MSOLEDBSQL

4. Save both the files and start the Enterprise Vault Services.

Solution

This issue has been addressed in the following releases:

Enterprise Vault 12.5.2

To support TLS 1.2 protocol Enterprise Vault had been upgraded to use MSOLEDBSQL driver while connecting to EV databases. The driver update change has been missing in the Usage.asp and ListVaults.asp files.