Error: “Unable to create vault 'TestVault' on computer 'M2020TestEDM.” when creating new SQL vault

This error can occur when trying to create a SQL vault.

In the event log, the error appears as:

HTIOError (ht5) (HTE_SQL_Failed=802).

Solution

Ensure the server has Microsoft OLE DB Driver for SQL Server installed to provide access to the SQL server.

See Meridian Application Server Requirements.