Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. : : .SQLServerException: The TCP/IP connection to the host 192.168.99.132, port 1433 has failed.Įrror: "null. Stack trace when connecting from Mac host to Windows 7 guest (note suspicious part in bold): Java HotSpot(TM) 64-Bit Server VM (build 20.10-b01, mixed mode)
Java(TM) SE Runtime Environment (build 1.6.0_35-b10) Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01-434, mixed mode) Or jdbc:jtds:sqlserver://192.168.99.132:1433/vha.Īny ideas why the Microsoft driver fails but jTDS succeeds from a remote host? And yes, I've tried the Microsoft URL with and without the instance name. If, from the Mac host, I use the jTDS SQL Server driver (version 1.2.7 because I'm using JDK6, so can't use jTDS 1.3.0 - that version is JDK7 only), I connect right away with both of the JDBC URLs jdbc:jtds:sqlserver://192.168.99.132:1433/vha instance=SQLEXPRESS However, when I try to connect to SQL Server from Squirrel on the Mac via the IP address 192.168.9.132 (can't resolve "winny"), I get an exception (see stack trace below). On the Windows 7 guest OS itself, I can connect to SQL Server just fine via the Microsoft JDBC driver using the machine names of either "winny", "localhost", or "192.168.99.132" (JDBC URLs like jdbc:sqlserver://winny\SQLEXPRESS:1433 databaseName=vha). I downloaded the Microsoft SQL Server 2012 JDBC driver (sqljdbc4.jar) along with Squirrel SQL client 3.4.0 for both Windows and Mac. The Windows 7 guest has IPv4 addressġ92.168.99.132 and Windows Firewall is turned off. TCP/IP on port 1433, not dynamic ports (setting is blank, not 0). I've got a Windows 7 SP1 guest (64-bit) withīridged networking running Microsoft SQL Server Express 2012. I'm on a Mac OS X 10.7.5 64-bit host running
0 kommentar(er)
