Cannot connect to MSSQL server database when installing ControlMinder 12.81

Products

• CA Privileged Identity Management Endpoint (PIM)

Issue/Introduction

While trying to install ControlMinder 12.8 SP1 ENTM in Windows, the MSSQL configuration always fails to connect to the remote MSSQL server, giving an error that the connection parameters did not work and that they need to be verified.

However, connectivity to the SQL server and to port 1433 there has been verified to work fine.There is no issue with that and it works just fine. It is possible to create the DB remotely with the user and password provided

Cause

This may be caused by TLS 1.1 and 1.0 being disabled in the remote SQL server for connection. PIM/ControlMinder 12.8 SP1 requires TLS 1.1 or 1.0 to connect to SQL

Environment

CA ControlMinder Release : 12.8

 

Resolution

In the SQL server you are trying to connect to and use as RDBMS server check that in

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\

In Keys TLS1.0 and TLS1.1 the protocol is enabled for client and server