Cannot connect to SQL Server

kjmauriello-999
Giga Contributor

I have a JDBC data source trying to download data from a sql server database.
I am getting this error from the data source:
The TCP/IP connection to the host ITS-KM-LAPTOP, port 1433 has failed. Error: "Connection refused: connect.

I verified the SQL Database is allowing remote access and port 1433 is open.  What do I need to allow access in the firewall.  Is it the SN instance name?  Something else?

Any assistance would be greatly appreciated.

Thank you

5 REPLIES 5

Hi, 

 

Is your SNOW and Server both on same network or VPN.

Ask you server admin to allow access to SNOW.


This will help.


Thanks,
Ashutosh Munot