JDBC Connection issue to SQL Server from RedHat Linux

manpreet Best Answer 2 years ago

I have two servers set up.

1. Windows Server 2016 with MS SQL Server Installed.

   SQL Server is on and running on port 1433 on localhost as well as the IP of the computer and I made sure the in Server Configuration Manager, the TCP connection is set to enabled and active,

   The firewall of the server is DOWN.

2. I have a RedHat 7 server trying to establish JDBC test connection to the windows server. This RedHat server can ping the Windows server and also I can telnet to the 1433 port from the RedHat server. I also made sure that the firewall is DOWN on this server.

However when I try to establish a JDBC test i always get : SQLstate 08s01

I have used wireshark on my Windows Server to see that the requests from my RedHat server are coming in to port 1433, But i don't know why MS SQL server is not responding.

I have also made sure that in the SSMS, i enabled : Allow remote connections to this server.

What could I be missing ? I have been on this for 24 hours with no results... I have also tried using different : com.microsoft.sqlserver.jdbc.SQLServerDriver jars.