Problem with connection at database SQL SERVER

[stefano.sforna]

Hi,
I have a problem to connect Vision to an instance of SQL SERVER.
I have do procedure as in the link Connecting to Microsoft SQL Server - Ignition User Manual 8.1 - Ignition Documentation

But I have this error of connection:

java.sql.SQLException: Cannot create PoolableConnectionFactory (Impossibile stabilire una connessione protetta a SQL Server mediante la crittografia SSL (Secure Sockets Layer). Errore: “No appropriate protocol (protocol is disabled or cipher suites are inappropriate)”.)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Impossibile stabilire una connessione protetta a SQL Server mediante la crittografia SSL (Secure Sockets Layer). Errore: “No appropriate protocol (protocol is disabled or cipher suites are inappropriate)”.
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

What’s the solution???

[pturmel]

See this topic:

SQL Server Connection Faulted

After replacing a development installation of Ignition 8.1 with 7.9.17, I am suddenly unable to communicate with my local SQL server. The connection was fine before the reinstall but now it’s faulted and showing this error: Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “No appropriate protocol (protocol is disabled or cipher suites are inappropriate)”.) I’ve double checked all t…

Summary:

1. Check your JDBC driver in Microsoft's support matrix, and

2. Edit java.security if your SQL Server is too old to use TLS 1.3