What the heck is "TCP Dynamic Ports" and why is it asking for a single port number? Well regardless, specifying the port numbers and restartingĮverything (SQLExpress, SQL Full-text Filter Daemon Launcher, SQL Server Reporting Services) does not help! Why not? jtds with named pipes still works, however, so I know it is not a java issue.Ĭould you elaborate a bit more? Is it merely a matter of starting the browser server? Specify 1433 for both the "TCP Dynamic Ports" and "TCP Port" and that does not help. Why is this? OK, so I look for the 127.0.0.1 and my network address (192.168.56.1) and explicitly Properties for TCP/IP (I confirmed that it is indeed enabled) and then click on the IPAddresses, I see quite a few entries but none of them have a TCP port specified. I specify port 1433 in my java code and I cannot connect. TCP with sql authentication does not work! Why?Ĭan someone help me get the same JDBC (jtds) driver work with TCP/IP sockets? I have used the SQL Server Configuration Manager to enable shared memory, Named Pipes and TCP/IP. (3) The type 4 open source (java JDBC) driver ( ) that uses sql authentication with named pipes also works! (2) The Microsoft (Java) JDBC driver that uses windows authentication works too.
(1) The enterprise client (SSMS) works great
0 kommentar(er)
