Hi Hendrik,
I also had no luck with the MS-SQL node. Instead I use the standard “DB Connector” with the following settings:
Connection Settings:
Database Type: Microsoft SQL Server
Database Dialect: Microsoft SQL Server
Driver Name: Official Driver for Microsoft SQL Server (Version 7.2)
Database URL: jdbc:sqlserver://;instancename=;databaseName=;integratedsecurity=true
Authentication: None
Leave all other settings with default values.
= PC or Server running the database engine
= SQL Server Instance you want to connect to
= the database in the selectet instance you want to connect to
Hope that helps!
Regards,
Karl