Error Message

The list of SQL Server computers or listeners below shows the network protocols that are supported by each server. EV requires at least one of the network protocols to be supported on each SQL Server.

DCSQL: NamedPipes (NO), TCP/IP (NO)

A test of the ODBC Connection to the SQL instance is successful.

A Dtrace of the Deployment_Scanner process shows below error:

(Deployment_Scanner)    <3148>    EV:H    Error accessing vault database 'Provider=MSOLEDBSQL;Integrated Security=SSPI;DataTypeCompatibility=80;Data Source=DCSQL;'|SQL Command: 'N/A'|Internal reference: CC1|Internal error code: 0x800a0e7a.

The Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) was not installed on Enterprise Vault Server 11 SP1 CHF5.

EV 12.4.1 and later supports the TLS 1.2 protocol for communication between the EV components and the SQL server. To support TLS 1.2, the Microsoft OLE DB Provider for SQL Server (SQLOLEDB) is replaced with the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL).

Installing the Microsoft OLE DB Driver 18 for SQL Server (MSOLEDBSQL) on the EV server will ensure that the Deployment Scanner check returns properly.  Using MSOLEDBSQL on an older EV version than 12.4.1 will not cause any connectivity issues as long as the SQLOLEDB is still available.

https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16

Note: Any required software that does not exist on the server will be installed during installation per the Enterprise Vault™ Installing and Configuring guide.