SQL Server Management Studio error Execute failed: Login failed for user

[Daniel_Weikert]

I have a local installation of SQL Server Management studio. I created a SQL Server Authentication login and tested it. However when I try to connect with Knime i get the following error

ERROR Microsoft SQL Server Connector 2:1 Execute failed: Login failed for user

any help?
thanks

[izaychik63]

It would be simple to answer if you provide a screenshot of failed node configuration.

[Daniel_Weikert]

Hi izaychik63,
sure, sorry for not attaching a screen. The config is pretty basic because windows authentication seem to be quite a hassle so i used the sql server auth
When I log in to SSMS directly i got no issues but using knime i got the error

ERROR Microsoft SQL Server Connector 0:1 Execute failed: Login failed for user

log
java.sql.SQLException: Login failed for user ‘xyz’.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:371)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at org.knime.database.connection.UrlDBConnectionController$ControlledDriver.connect(UrlDBConnectionController.java:95)
at org.knime.database.connection.UrlDBConnectionController.createConnection(UrlDBConnectionController.java:306)
at org.knime.database.connection.UserDBConnectionController.createConnection(UserDBConnectionController.java:249)
at org.knime.database.connection.AbstractConnectionProvider.createConnection(AbstractConnectionProvider.java:89)
at org.knime.database.connection.impl.DBConnectionManager.lambda$2(DBConnectionManager.java:370)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

[izaychik63]

Did you install MS SQL JDBC Driver?

[Daniel_Weikert]

Thanks I have tried that but now the only difference is that the error message contains an additional client connection id

“ERROR Microsoft SQL Server Connector 0:1 Execute failed: Login failed for user ‘xyz’. ClientConnectionId:e493220b-63…”

[ipazin]

Hi there @Daniel_Weikert,

did you manage to resolve your issue and connect?

Br,
Ivan