I have a configuration for connecting to a SQL Server on my local machine. While trying to connect from docker container, I get below error:
Error: Java::ComMicrosoftSqlserverJdbc::SQLServerException: The port number 18.104.22.168:49172 is not valid.
I have created inbound/outbound rules in my Windows Firewall Settings to accept connections for/from this port.
Can anyone help me understand what's going wrong?
A combination of an IP and port is indeed not a valid port number. What does your configuration look like?
jdbc_connection_string => "jdbc:sqlserver://tcp:22.214.171.124:49172;databasename=testdb;"
I tried giving machine name as well instead of ip address, but it gave same error.
What happens if you remove the "tcp:"?
Actually initially my sql server was not connecting from any other machine in network. So I open all ports to access and was able to connect by adding a "tcp:" in front of hostname. But somehow I suppose that's not required in the configuration file.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.