In our case option EXTRA_OPTION_MSSQL.ssl=require is needed for SQL Server connection.
Without this option some errors occured:
2023/08/17 07:21:32 - org.pentaho.di.trans.steps.tableinput.TableInputMeta@2f1bf1c2 - Error occurred while trying to connect to the database
2023/08/17 07:21:32 - org.pentaho.di.trans.steps.tableinput.TableInputMeta@2f1bf1c2 -
2023/08/17 07:21:32 - org.pentaho.di.trans.steps.tableinput.TableInputMeta@2f1bf1c2 - Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed.
2023/08/17 07:21:32 - org.pentaho.di.trans.steps.tableinput.TableInputMeta@2f1bf1c2 - I/O Error: DB server closed connection.
Hence it may be useful for have some -sforce_ssl flag (like -pforce_ssl).
In our case option
EXTRA_OPTION_MSSQL.ssl=require
is needed for SQL Server connection.Without this option some errors occured:
Hence it may be useful for have some
-sforce_ssl
flag (like-pforce_ssl
).