0

I have to move data from SQL Server to AWS Redshift. For the ETL process, I'd like to use AWS glue and connect to my source (SQL Server), but I always get the following error message when testing the connection.

Error:

"Check that your connection definition references your JDBC database with correct URL syntax, username, and password. The TCP/IP connection to the host, 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."

Ports are correctly opened on my local laptop.

Here is the connection string used:

jdbc:sqlserver://serverip:1433;databaseName=AdventureWorksDW2012

I'm not sure what's the issue at this point?

Could someone please tell me the steps that how i can connect onprem database using aws glue?

Thanks in Advance!

Dale K
  • 25,246
  • 15
  • 42
  • 71
Lalit Kothawade
  • 13
  • 4
  • Does `serverip` match the address returned by [https://icanhazip.com/](https://icanhazip.com/)? Presumably you're sitting behind a NAT-based router, so have you opened a port mapping rule from the router's external port 1433 to port 1433 on your laptop's internal IP address? – AlwaysLearning Feb 22 '23 at 21:27

0 Answers0