I have a cognos reports server that is connecting to a SQL 2008R2 database and after a recent restart the JDBC driver is giving an error message Pasted at bottom.
I cannot figure out why it wants to connect SSL all of a sudden. The OS is Windows Server 2008R2 The JRE is 6.0 SQL 2008R2 x64
I have checked the SQL server Forced Encryption is set to NO
I have checked that FIPS is not enabled in group policy and the registry on both servers.
I have verified I can connect to the SQL server using other means I. e. SQL Studio, telnet , SQLPing, UDL connection
I cannot figure out why it is trying to connect SSL It connect correctly before the restart
:[trycatch] Caught exception: com.microsoft.sqlserver.jdbc.SQLServerException:
the driver could not establish a secure connection to SQL Server by using Secure
Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed.".
[echo] ERROR: com.microsoft.sqlserver.jdbc.SQLServerException: The driver
could not establish a secure connection to SQL Server by using Secure Sockets Lay
er (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed.".
Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…