none
Why ODBC connection to SQL Server on Virtual Machine failed?

    Question

  • I have Windows 8 workstation virtual machine running Windows Server 2008R2 and SQL Server 2008R.
    IP of Virtual machine is 10.10.0.9. I can succesfully ping it from workstation.
    I have created SQL account "test". I have tested that I can login to studio with this account. SQL Server instance name is "Lion".
    I have not done any specific configuration in SQL Server.
    I turned off all Windows Firewall on Windows 8 for testing purpose. Firewall on server is off too.

    I have now create ODBC connection in Windows 8.
    -Server name is "10.10.0.9".
    -Authentication is SQL login with "test"
    -Default settings with other configuration

    Then I clicked "Test Data Source" and error occured. Why?

    Microsoft SQL Server Native Client Version 11.00.2218

    Running connectivity tests...

    Attempting connection
    [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [1326].
    [Microsoft][SQL Server Native Client 11.0]Login timeout expired
    [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

    TESTS FAILED!


    Kenny_I


    • Edited by Kenny_I Thursday, July 11, 2013 11:32 AM update
    Thursday, July 11, 2013 11:26 AM

Answers