2
I have set up sql server express 2014 in a Windows 7 virtualbox guest, but I cannot connect to it using the jTDS JDBC driver from my Ubuntu host. I get a Could not retrieve database information
error. I feel like I must be missing a step somewhere, but can't find anything online that I haven't already tried:
- Connection URL is
jdbc:jtds:sqlserver://192.168.56.1:1433/dbo;instance=SQLEXPRESS
- Windows firewall has been disabled completely on the guest.
- I can ping the guest IP address from the host.
- The server and SQL Browser services are running.
netstat -a
on the guest confirms that TCP 0.0.0.0:1433 and UDP 0.0.0.0:1434 are listening.- The server logs say
Listening on <All IPv4>:1433
- The Surface Area Configuration tool has TCP/IP enabled and set up to listen on port 1433 for all IPs.
- SSMS confirms remote access is enabled for that server instance.
- I can connect to the database from SSMS on the guest using the host-only IP address (192.168.56.1, same as above) and the same SQL Authentication credentials that I am using over JDBC.
telnet 192.168.56.1 1433
andtelnet 192.168.56.1:1434
from the host both fail immediately withConnection refused
, while the same commands from the guest do not.
It feels to me like a firewall issue since I seem to be able to connect on the interface IP address from inside the guest and the output from netstat
, but with Windows firewall turned off I am not sure what to do next, or even what diagnostic steps to take from here.
Worked first time on the bridged adapter. – erm410 – 2015-03-23T15:39:42.107
Glad I could help ;-) – Louis Parkin – 2015-03-23T20:05:40.213
After thinking on this a bit more, I suspect your initial issue was not the host-only adapter's fault, but rather a more trivial issue related to IP addresses being in different ranges. The host-only IP is usually nowhere near being in the same range as your actual Ethernet IP. Adding an alias IP on your host machine could probably have resolved this issue as well. – Louis Parkin – 2015-04-01T10:33:15.870