JDBC sender adapter error

[Former Member]

We are having an issue whilst setting up a JDBC sender adapter from XI to a SQL server hosted application. We were able to run the connection in INT environment but getting error in Pre-Prod environment. Also, XI Pre-Prod system is able to connect to target application's INT server. By XI pre-prod to target Pre-Prod is coming up with error. There is no difference on XI servers in terms of JDBC library version. Also, firewall issue is ruled out.

Below is the error log from XI JDBC adapter:

Error during database connection to the database URL 'jdbc:sqlserver://database.company.com\application_server:port;DatabaseName=INSTANCE' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. com.microsoft.sqlserver.jdbc.SQLServerDriver returns: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: The TDS protocol stream is not valid... : com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: The TDS protocol stream is not valid..'

[baskar_gopalakrishnan2]

Your jdbc driver is not valid. Please go to microsoft site and search for the latest version. But you have to keep one thing in mind that driver versions are based on JDK.  Again PI versions are again based on JDK too.  If you use 7.0, you need jdk 1.4 or less whereas if you use 7.1 and above, you would use jdk 1.5 +.  So based on PI/java versions you have to use the corresponding sql server jdbc driver.  Hope that helps.

[ambrish_mishra]

Hi,

Please check the link below:

http://blogs.msdn.com/b/saponsqlserver/archive/2011/12/02/microsoft-jdbc-driver-1-2-sqljdbc-driver-f...

Specifically the context:

This is a known issue of this version of the Microsoft JDBC driver. This version of the driver cannot use SSL if the SQL Server uses a certificate that is larger than 4KB. Even if the NetWeaver AS Java does not use SSL to connect to your SQL Server, the login information (user and password) are still encrypted.

The recommendation is to switch to a newer version of the Microsoft JDBC driver. This solution is valid for SAP systems based on NetWeaver 7.1 and higher.

It also refers to SAP Note 1428134.

Hope it helps!

Ambrish