Odbc connection dont work

ZionAssedo

New Member
Hi,
I'm running a MSSQL 2012 server in a 2012 R2 server in a VM and I want to create an odbc connection on my host computer.
The IP address of my VM is 192.168.42.146 and I can ping the VM from the host as well, but when trying to establish an ODBC connection to the Sql server it fails.
The Sql server instance name is WIN-74DOGP6POB3 so in the dsn wizard I specified \\192.168.42.146\WIN-74DOGP6POB3, what is wrong ?

Help will be much appreciated.
 

Peter Schmitz

Administrator
Staff member
Hi!

Try and remove the double slash in front of the IP-address. I.e. just supplying 192.168.42.146\WIN-74DOGP6POB3

Hope this helps. If not, please show us some screenshots of how you're setting things up, and perhaps include the error message you receive.

Thanks!

/Peter
 

ZionAssedo

New Member
Hi Peter,
I did what you suggested but it didnt help.
The strange thing is that I can telnet the port as well also, here is the error message I get from the test connection :

upload_2016-3-15_13-39-29.png
 
Top