Solved

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

Posted on 2011-02-14
2
3,139 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
2 Comments
 
LVL 17

Accepted Solution

by:
paulop1975 earned 500 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 84
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

HOW TO: Install and Configure VMware vSphere Hypervisor 6.5 (ESXi 6.5), Step by Step Tutorial with screenshots. From Download, Checking Media, to Completed Installation.
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

759 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now