15
Views
3
Comments
Database Connection Fails

Hi,

I created a database connection to an External SQL Server and when I try pressing Test Connection, the following error appears:

Connection String test failed: 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.) 

Any idea of solving this issue.

Regards,

Shah

mvp_badge
MVP
Rank: #43

Hello Shah,

Are the credentials for the SQL server a simple user/password or is it more involved? How do you access it directly without OutSystems involved? What version is it?

Rank: #461

HI Shah
Can you tell us the  External SQL Server'version and Outsystems platform's version.

The issue looks related to SSL(TLS) version they supported.

Please refer links below.

https://stackoverflow.com/questions/26742054/the-client-and-server-cannot-communicate-because-they-do-not-possess-a-common-a

or just google for "The client and server cannot communicate, because they do not possess a common algorithm. "

Kindly Regards


Rank: #395

Hi Shah,

Please refer the links .

https://www.admin-enclave.com/en/articles/windows/245-resolved-the-client-and-server-cannot-communicate,-because-they-do-not-possess-a-common-algorithm.html#:~:text=(provider%3A%20SSL%20Provider%2C%20error,not%20possess%20a%20common%20algorithm.)&text=So%20make%20sure%20that%20your,wish%20to%20disable%20TLS%201.0.


https://stackoverflow.com/questions/26742054/the-client-and-server-cannot-communicate-because-they-do-not-possess-a-common-a

hope this help you