Cannot connect to SQL Server

kjmauriello-999
Giga Contributor

‎03-10-2018 08:36 AM

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

Labels:
0 Helpfuls
  • 1,468 Views
5 REPLIES 5

Ashutosh Munot1
Kilo Patron
Kilo Patron

‎03-10-2018 11:06 AM

HI,

 

Is it via Mid server?


Thanks,

Ashutosh Munot

0 Helpfuls

kjmauriello-999
Giga Contributor
In response to Ashutosh Munot1

‎03-10-2018 09:26 PM

yes it is

0 Helpfuls

Ashutosh Munot1
Kilo Patron
Kilo Patron
In response to kjmauriello-999

‎03-11-2018 01:20 AM

Hi,

 

Great! So now can you check if the user you are using in Mid Server has proper right to contact the server you have used to read the data.

 

Thanks,

Ashutosh munot

0 Helpfuls

kjmauriello-999
Giga Contributor

‎03-12-2018 02:46 PM

The user does have access to the database I am trying to connect to.

Because of the error "Connection refused" I am thinking I need to give SN access through the firewall.  But I am not sure how to do that

0 Helpfuls