mid server jdbc to MS SQL server

chercm
Mega Sage

i kept getting error : the tcpip connection to the host at port 50000 (SQL server ) have faild . error "null. Verify the connection properties / Make sure that an instance of the SQL server is running on the host. make sure that TCP connection to the port are not blocked by firewall. 

 

From the firewall closest to the mid server , i am not seeing failed attempt at port : 50000 

 

if connecting manually it is working and the user id works. 

 

Any idea how to fix this ? i am trying to pull in badge information from the sql server which is hosting them and to put into the user badge table. 

1 REPLY 1

chercm
Mega Sage

i have applied for access from the firewall -> source (mid server ) to the DB - destination ( 50000) . is there any other ports i need to apply access on ?