AWS Datalake Glue Connection timeout SQL Server

Hi TEam, Me ew to AWS Data lake configuration. As per the doc, it refers to create the Glue connection which will be internally used by AWS BluePrint. My database is running on EC2 instance of different AWS accounts.

I have setup the connection using jdbc with connection string "jdbc:sqlserver://SRV_IP:1433;database=db_name" and "jdbc:sqlserver://SRV_IP:1433;database=db_name", but the test connection failed with following error:

Check that your connection definition references your JDBC database with correct URL syntax, username, and password. The TCP/IP connection to the host SRV_IP, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

Following already configured/tested,

1. The connection security group has inbound traffic for port,
2. the subnet used in connection has the route table points to NAT gateway, 3)Able to connect the DB over the internet hence no issue with db/ec2 security group.

Please advise. me referring: https://aws.amazon.com/blogs/big-data/integrating-aws-lake-formation-with-amazon-rds-for-sql-server/ Except the DB is self-managed on AWS EC2.

REgards, Nikhil Shah