Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Odbc connection dont work

Discussion in 'General' started by ZionAssedo, Mar 15, 2016.

  1. ZionAssedo

    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.
  2. Peter Schmitz

    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
  3. ZionAssedo

    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

Share This Page

Sponsored link: