SQL Server login not working using SQL Server Change Tracking Origin

asked 2020-06-07 08:21:20 -0500

Hi Team, I am trying to configure SQL Server Change Data Tracking and I am getting error. I am connecting to the database using the below JDBC String: jdbc:sqlserver://server:port;database=databasename and Credentials as: Username:domain\username Password: password : I have installed external library sqljdbc42.jar. The SQL Server Version is 12.0.6329 SP3 and Authentication Method: Windows Authentication I am able to login to the server through SSMS using the above username and password. I am able to ping and telnet the SQL Server server from the SDC but I am getting following error from SDC.

Error: 2020-06-07 07:27:31,369 <program name=""> (SCH Test Run)/testRun__b6169a7e-5ec4-4704-b5ca... ERROR HikariPool-15 - Exception during pool initialization. HikariPool *user@org.com preview-pool-2-thread-3 : Login failed for user 'domain\username'. ClientConnectionId:e94effd0-0d5c-412d-af7a-d2155ad80fdd at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:258)</program>

Appreciate if anybody has any inputs on JDBC drivers & windows authentication support for SQL Server.

edit retag flag offensive close merge delete