Link to home
Start Free TrialLog in
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )Flag for United States of America

asked on

Connect to SQL Server (on host) from vmWare Workstation 7.1.3

I'm trying to connect to my SQL Server 2008 R2 server on my host OS.

I'm running a vmWare Windows XP instance. The host OS is Windows 7 Ultimate.

On the host, I've installed SQL Server 2008 R2. From the host, I can successfully connect to that server and the databases on it using local .NET apps, Management Studio, and several other utilities.

I cannot connect to that SQL Server from my vmWare Windows XP instance. I can successfully connect to the host through the "Network Places" section on my vmWare instance, and I can browse shared folders on the host. I've tried connecting through an Access application, an through a VB.NET apps. Both are apps I wrote, and both can connect to the SQL server if I run those apps on the host OS.

I also tried to build an ODBC connection using the ODBC Data Source Administrator, trying both a File and System DSN, and using Windows and SQL Authentication. The Server is set to handle both types of authentication. The server is also set to allow remote connections.

I'm using NAT in the Network Adapter settings. I've tried the Bridged and host-only settings, with no luck. I've turned the Windows Firewall OFF on both the host and guest.

I'm obviously missing something, but have no idea what. Any assistance would be greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Paulo Pimenta
Paulo Pimenta
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Scott McDaniel (EE MVE )

ASKER

Yes I do. However, I did NOT have "Named Pipes" enabled. I did that, restarted the service, and I can now connect.

Thanks!