Hi all,
got the same problem here. Want to connect to our SQL Cluter Instance with Windows Authentication. It's no solution for us to use SQL Authentication (could work already) because of our permission restrictions in the company.
When executing i'll receive an error:
Execute failed: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'myUsername'. ClientConnectionId:a25b7435-6db2-4c5a-9d39-fff5fb66d288
Could anyone help to find out where the problem is?
Thank you for any Help.
Cheers
Here is my Configuration:
Version:
KNIME 2.11.3
--launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.1.100.v20110502
SQLJDBC Database Driver:
C:\Program Files\KNIME_2.11.3\plugins\jp.co.infocom.cheminfo.jchemlib_14.11.24.0\lib\sqlidbc4-4.0.jar
Microsoft JDBC Driver 4.1 (x64):
-Djava.library.path=C:\Program Files\KNIME_2.11.3\jre\bin\sqljdbc_auth.dll
Connection:
Database URL:
jdbc:sqlserver://ClusterInstance01\ClusterInstance01;databasename=CustomerDatabase
Username & Password:
defined and valid
Tests:
with ODBC - No problems with the SQL Server Native Clients
with integrated security - No problems (with this database url - jdbc:sqlserver://ClusterInstance01\ClusterInstance01;databasename=CustomerDatabase;integratedSecurity=true)