Ticket #11027 (closed defect: obsolete)

Opened 6 years ago

Last modified 3 years ago

Unable to connect to SQL Server 2012 client via ODBC from host

Reported by: Ambrose Owned by:
Priority: major Component: network
Version: VirtualBox 4.2.0 Keywords:
Cc: Guest type: Windows
Host type: Windows


I have MS Access 2010 on the Windows 7 VirtualBox host, which connects fine to every other SQL Server in the workgroup except the SQL Server 2012 installed on the VirtualBox Windows 7 guest.

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

Change History

comment:1 Changed 3 years ago by frank

  • Status changed from new to closed
  • Resolution set to obsolete
Note: See TracTickets for help on using tickets.
ContactPrivacy policyTerms of Use