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 .
[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.
Edited byKenny_IThursday, July 11, 2013 11:32 AMupdate
Before going further, I want to confirm whether you means that you have a Windows 8 workstation with a virtual machine (running Windows Server 2008R2) on it, and you installed SQL Server 2008 R2 on Windows Server 2008R2 virtual machine. Now, you want to
create ODBC connection to SQL Server 2008 R2, but it failed. If there is any misunderstanding, please let me know.
1. Please configure Windows Firewall on Windows Server 2008R2 virtual machine side rather than Windows 8 workstation side.
2. Please enable SQL Server remote connection option.