?
Solved

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

Posted on 2011-02-14
2
Medium Priority
?
3,397 Views
Last Modified: 2012-08-13
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.
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 17

Accepted Solution

by:
paulop1975 earned 2000 total points
ID: 34889488
Do you have TCP/IP enabled on SQL Server 2008?
Start > All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager.
 SQL Server TCP/IP Enabled
0
 
LVL 85
ID: 34889706
Yes I do. However, I did NOT have "Named Pipes" enabled. I did that, restarted the service, and I can now connect.

Thanks!
0

Featured Post

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question