SQL Server connection : TDS protocol stream is not valid

KNIME Analytics Platform
1

Hello,

So far I have been successful querying a company SQL Server using the DB Connector and the ‘Official Driver For MS SQL Server’ downloaded from as an extension. Now, however, as I am operating from home, some sort of a timeout seems to kick in and anything other than very small queries stop with:

Execute failed: com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid.

error.

For some reason I have never been able to successfully connect using either the SQL Server Connector or the jDTS driver, so I don’t seem to have much other options than getting this one to work.

Any suggestions as how to fix it?

2

Hi,
can you please provide the full error message. You should find it in the KNIME log file.
Please be sure to not include any sensitive information into your reply such as host, database and user names.
Thanks
Tobias

3

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.