Microsoft SQL server Login failed for user "x"

Hi everybody,

In this last 2 days i am trying everything to connect my Microsoft sql DB to KNIME with

• Microsoft SQL server connecter

• DB connecter nodes

It always gives the same error: Login failed for user "x"

Database, instance, port names are all correct (doubled check from sql server with queries) and i can access to this DB with SQL management studio and power bi without problem. I have a KNIME 5.11.1. and DB SQL19

What i tried so far with Windows authentication/user and password options:

• Creating all the parameters of parameters that i see in the management studio connection page as they are setted.

  

• I also tried it with encrypt and trustserver=true

• Downloading and implementing JDBC Driver for SQL with integratedSecurity=true and none/authentication

• using JDBC parameters nodes

• I read kinda every solution i saw in knime forum.

• I went to knime log and the error is this:

2026-06-19 09:42:05,011 : INFO : KNIME-Database-Connection-Creator-3 : : UrlDBConnectionController : Microsoft SQL Server Connector : 3:3 : Could not create connection to database using URL: jdbc:sqlserver://SERVERNAME:1433;databaseName=DBNAME and parameters: [password, encrypt, sendTimeAsDateTime, trustServerCertificate, user]. Exception: L'acccesso non è riuscito per l'utente 'X'. ClientConnectionId:c7de8b55-d605-4eda-b0e1-2dce5c969c12

2026-06-19 09:42:05,011 : ERROR : KNIME-Worker-2-Microsoft SQL Server Connector 3:3 : : Node : Microsoft SQL Server Connector : 3:3 : Execute failed: L'acccesso non è riuscito per l'utente 'X'. ClientConnectionId:c7de8b55-d605-4eda-b0e1-2dce5c969c12

com.microsoft.sqlserver.jdbc.SQLServerException: L'acccesso non è riuscito per l'utente 'X'. ClientConnectionId:c7de8b55-d605-4eda-b0e1-2dce5c969c12

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:356)

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:333)

at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:337)

at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:137)

at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:7722)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:6147)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:6079)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7832)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:5024)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:4412)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3937)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:3700)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:2385)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1453)

at org.knime.database.connection.UrlDBConnectionController$ControlledDriver.connect(UrlDBConnectionController.java:104)

at org.knime.database.connection.UrlDBConnectionController.connect(UrlDBConnectionController.java:369)

at org.knime.database.connection.UserDBConnectionController.connect(UserDBConnectionController.java:307)

at org.knime.database.connection.UrlDBConnectionController.createConnection(UrlDBConnectionController.java:349)

at org.knime.database.connection.AbstractConnectionProvider.createConnection(AbstractConnectionProvider.java:104)

at org.knime.database.connection.impl.DBConnectionManager.lambda$4(DBConnectionManager.java:595)

at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.base/java.lang.Thread.run(Unknown Source)