Ticket #11027 (closed defect: obsolete)
Unable to connect to SQL Server 2012 client via ODBC from host
|Reported by:||Ambrose||Owned by:|
No other Windows 7 MS Access 2010 machine in the workgroup can connect to this VirtualBox guest version of SQL Server 2012 either, but they can connect to other SQL Servers installed in exactly the same way on non-virual Windows 7 machines using the same ODBC drivers.
I installed Access 2010 on this aforementioned VirtualBox guest and it works just fine with the local version of SQL Server 2012 on the same guest.
I am using the VirtualBox 4.2 bridged networking type with all the defaults. I can connect network drives on the guest and transfer data from the guest, no problem. Only SQL Server ODBC has any trouble connecting to this host (SQL Server error 10060) and the same driver connects fine to other hosts.
Oh, and SQL Server 2012 "Allow External Connections' is 'Yes', TCP/IP and Named Pipes are enabled for the clients, and the firewall is off for the guest. Doesn't work whether the SQL Server Browser Service' is on or off, and there's no reason this should matter with only one instance of SQL Server on the default port, 1433.
This is truly bizarre, everything works fine except an ODBC connection to the guest Windows 7 SQL Server 2012