question

Shantanu Sen avatar image
Shantanu Sen asked

JDBC connection exception:The TDS protocol stream is not valid

We are having an issue with any java client trying to connect to a specific SQL server 2005 installation. The jdbc client is showing the following error in the log:

WARNING: TDSReader@1b3f8f6 ( ConnectionID:1 TransactionID:0x0000000000000000) Unexpected message type:18 in TDS header; expected type:4 Oct 23, 2009 3:51:19 AM com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS SEVERE: TDSReader@1b3f8f6 ( ConnectionID:1 TransactionID:0x0000000000000000) got unexpected value in TDS response at offset:4088

It looks like an issue with the size of the SSL certificate returned by the server as mentioned in the following link

http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/6a0263ab-e35f-41b3-b4ca-fcdb1cfc8ac6

The strange thing is that the SQL server is NOT configured with SSL - in the configuration we can see that the Force Encryption is set to NO and there are no certificates installed.

Yet, when we look at the trace generated by the jdbc client, we see the SSL handshake sending certificates.

Where can we look to see why the certificates are being sent even though the SQL server installation is not configured with SSL?

Any help will be highly appreciated.

Thanks, Shantanu Sen

sql-server-2005ssl
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.