I need to connect to a SQL Server on EC2 which is hosted on AWS in the Company's network from a Managed Service (Collibra DGC) which is on AWS Account on Vendors (Collibra's) network. I am using a JDBC JTDS driver and authentication menthod as Windows Authentication (NTLMv2) as this is the only way I can connect due to security restrictions.
Connection URL used:
jdbc:jtds:sqlserver://server:1433/sampledb;USENTLMV2=true;domain=domain;
note: I am providing the username and password at a different place in the UI. This information is for people who are not familiar with Collibra catalog functionality.
Driver class: net.sourceforge.jtds.jdbc.Driver
I am seeing below error on trying to make a connection:
(Error on the Database End)
Error: 17806, Severity: 20, State: 14. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed [CLIENT: xx.xx.xx.xx] Error: 18452, Severity: 14, State: 1. Login failed. The login is from an untrusted domain and cannot be used with Windows
Appreciate if anyone can help figure out a solution or any other approach for connectivity.
User contributions licensed under CC BY-SA 3.0