SSL connection error from SQL server in Websphere

Question

WE are connecting to SQL server from our WAS(websphere). Connection is fine before we made the data present in SQL server encrypted and made the connection as SSL. From that onwards, we are getting SSL connection error. BUt we had installed the certificates under trusted key store in WAS console. Below is the error. Any help is appreciated. Thanks in advance.

Could not get JDBC Connection; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: [IBM][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.DSRA0010E: SQL State = 08001, Error Code = 0

RAD version is 7.5.5 WAS version is Websphere Application Server 6.1

Answer 1

Issue resolved by installing SQL server drivers in WAS console. Not sure how it worked before encryption without drivers.

Thanks.

Answer 2

If you have SSL configured correctly, then I'm not sure what the following portion of the error mean:

The SQL Server login requires an SSL connection.DSRA0010E: SQL State = 08001, Error Code = 0

A StaleConnectionException is explained in the IBM link below: http://www-01.ibm.com/support/docview.wss?uid=swg21063645

Perhaps if you paste the entire error stack we can see more clues. Is there a 'caused-by' clause for example? If this issue only occurred right after you have enabled SSL then you would also want to make sure both parties have common cipher suites.