Collibra Connecting from DGC instance hosted on Vendors AWS account to SQL Server on EC2 within Company's Network

0

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.

amazon-web-services
asked on Stack Overflow May 14, 2021 by Uday Shankar Chejerla • edited May 18, 2021 by Uday Shankar Chejerla

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0