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

Mano · Accepted Answer · 2014-11-12 09:15:20Z

2

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

Thanks.

answered Nov 12, 2014 at 9:15

Mano

1431 gold badge2 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

wFateem · Accepted Answer · 2014-11-11 10:20:17Z

1

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.

answered Nov 11, 2014 at 10:20

wFateem

3561 gold badge2 silver badges11 bronze badges

4 Comments

Mano Over a year ago

Hi, I copied the error from "Caused By" Caused by: 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

wFateem Over a year ago

Ok, so the JDBC driver is telling us that the server requires SSL, which means for some reason the connection you're making is not being made using SSL protocol. Can you paste the entire error stack?

Mano Over a year ago

Hi Fateem, Thanks for the replies. Thats the entire error stack I can get from logs.

wFateem Over a year ago

What version of Microsoft SQL Server are you using and what's the JDBC driver version?

Collectives™ on Stack Overflow

SSL connection error from SQL server in Websphere

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related