Applications Systems

Enable SSL from DPA to SQL Server Repository

How to enable SSL from DPA to a SQL Server repository.

First published date

4/24/2019 2:57 PM

Last published date

7/9/2025 10:24 PM

Overview

The SQL Server repository changed to require SSL to the repository.  DPA will not start, and returns the following error:

A connection to the Repository <name> using the URL [XXX:1433/DATABASE;encrypt=true;trustServerCertificate=true;authentication=NotSpecified] could not be established. This typically occurs if the host or port is temporarily or permanently unavailable. If the host or port has permanently changed, edit host/port parameters in <DPA Home>/iwc/tomcat/ignite_config/idc/repo.properties.


Error_KB.jpg

Another error message is the following:

Error: Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library

RepositoryMonitor:XXXX - A connection to the Repository could not be established [cause=org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource[ identityToken -> XXXXX, dataSourceName -> XXXXX ] has been closed() -- you can no longer use it.]

Product section

Database Performance Analyzer

Cause

This issue occurs due to SSL was set to required by the SQL Server repository.

Resolution

  1. Edit  C:\Program Files\Solarwinds\DPA\iwc\tomcat\ignite_config\idc\repo.properties.
  2. Add the following line to the bottom of the file: 
    repo.additionalProperties=ssl\=request
  3. Restart DPA.