Symptoms

When installing or upgrading the XIA Configuration Server you see the error


A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not possess a common algorithm.) (Microsoft SQL Server, Error: -2146893007)


Cause

This can occur when security protocols such as TLS 1.0 are disabled, however other protocols are not available.


The connection from SQL Server Management Studio (SSMS) also fails with the same error.




Resolution


  • Review the security configuration of the machine where you are installing XIA Configuration Server and where SQL Server is installed and ensure that these are set correctly.

  • If you have disabled TLS 1.0 ensure that the version of SQL Server that you are running supports newer protocols.