ASP Developer Network - Brought to you by Steve Radich and BitShop, Inc. - http://www.bitshop.com

ASPDeveloper

ASPDeveloper.Net / VirtualServerFAQ.COM

Make sure you go to our home page for:

* Virtual Server 2005 FAQ
* ASP.Net 2.0 Information
* ASP.Net 2.0 Streaming Tutorials
* ASP.Net 2.0 HTML based Tutorials

Made possible by Business Internet Technology Shop (BitShop)

Virtual PC

Recent Virtual PC posts

* VPC for Main Stream Development?
* tftp server on guest system stalls
* Virtual PC in Restart Loop
* 32bit VPC on 64bit
* using virtual pc to publish web site on it
* Internet connection when box uses wireless USB?
* Virtual Applications Limited to Primary Monitor?
* putting windows server 2003 on vpc
* Unable to install MS Office 2007 on virtual WinXP
* forcing a dynamically expanding VHD to expand ?
* How do I restore recent items in Virtual PC list (on Windows 7)?
* Can"t allocate available memory to Windows Virtual PC VM on Window
* Install server 2008 Virtual PC
* WFW 3.11
* weird VPN issue from XP guest
* virtual pc 2007 and additions
* can"t ping from windows 7 to xp mode
* Urgent VPC Issues!
* Odd networking issue
* XP Mode as "Server"

Add Solution

How do I get the guest OS to see a SQL server running on the host

Source: microsoft.public.virtualpc
Sent: 12/22/2009
From: Dan Maharry
Message:

HI,
I've got Windows XP Mode running on Wndows 7 Professional x64. I have an
instance of SQL 2008 running on Windows 7 which I would like my copy of
VS2010b2 Pro running in WinXPMode to see. However, I cannot figure out the
right combination of networking and firewall adjustments to make. Below is
what I've done so far. Can someone help me out with what I've left to do to
get this working?

Thanks, Dan

- Installed Loopback Adapter on Host OS
- Set up Loopback Adapter to have a static IP address 192.168.3.1 which the
VPC network adapter will use as its internet gateway.
- Configured the XP Mode Virtual Machine to use the loopback adapter.
- Gave the network connection in XP mode the static IP address 192.168.3.2.
and the default gateway as 192.168.3.1.

At this point I can ping my host OS from my guest OS.

- Added incoming rules to my Win7 firewall for port 1433/TCp and 1434/UDP
and also for sqlsrvr.exe
- Opened SQL Server Configuration Manager and Enabled Named Pipes and TCP/IP
for your SQL Server on my host OS
- Within properties for TCP/IP, added entry for IP 192.168.3.1 on port 1433

However, I still cannot telnet to my host OS port 1433 or 1434 from within
my guest OS and have run out of ideas.

Post Reply | This is Spam! | Mark as Spam

Related Messages

Re: How do I get the guest OS to see a SQL server running on the host

Sent: 12/23/2009
From: Robert Comer <(email address - cut out)>
Message:

To make sure it's a firewall issue, try disabling the firewall for the
loopback adapter, then you'll know if that's the problem.

My guess is that you have a firewall zone problem, but the above will
tell you if it's the firewall at all that's the problem.

Also, do you have more than one network adapter assigned to the VM?

--
Bob Comer

On Tue, 22 Dec 2009 16:15:01 -0800, Dan Maharry
<(email address - cut out)> wrote:

Show quoted text

>HI,
>I've got Windows XP Mode running on Wndows 7 Professional x64. I have an
>instance of SQL 2008 running on Windows 7 which I would like my copy of
>VS2010b2 Pro running in WinXPMode to see. However, I cannot figure out the
>right combination of networking and firewall adjustments to make. Below is
>what I've done so far. Can someone help me out with what I've left to do to
>get this working?
>
>Thanks, Dan
>
>- Installed Loopback Adapter on Host OS
>- Set up Loopback Adapter to have a static IP address 192.168.3.1 which the
>VPC network adapter will use as its internet gateway.
>- Configured the XP Mode Virtual Machine to use the loopback adapter.
>- Gave the network connection in XP mode the static IP address 192.168.3.2.
>and the default gateway as 192.168.3.1.
>
>At this point I can ping my host OS from my guest OS.
>
>- Added incoming rules to my Win7 firewall for port 1433/TCp and 1434/UDP
>and also for sqlsrvr.exe
>- Opened SQL Server Configuration Manager and Enabled Named Pipes and TCP/IP
>for your SQL Server on my host OS
>- Within properties for TCP/IP, added entry for IP 192.168.3.1 on port 1433
>
>However, I still cannot telnet to my host OS port 1433 or 1434 from within
>my guest OS and have run out of ideas.

Re: How do I get the guest OS to see a SQL server running on the h

Sent: 12/23/2009
From: Dan Maharry
Message:

Hi Robert,

It was definitely the firewall that's the issue. Disabling the firewall had
it connecting fine. By luck I seem to have got it working with the Firewall's
troubleshooting wizard and telling it to open incoming connections for
sqlservr.exe. Which worked for some reason although I don't know what it
changed.

Thansk for your help.

Dan

"Robert Comer" wrote:

Show quoted text

> To make sure it's a firewall issue, try disabling the firewall for the
> loopback adapter, then you'll know if that's the problem.
>
> My guess is that you have a firewall zone problem, but the above will
> tell you if it's the firewall at all that's the problem.
>
> Also, do you have more than one network adapter assigned to the VM?
>
> --
> Bob Comer
>
>
> On Tue, 22 Dec 2009 16:15:01 -0800, Dan Maharry
> <(email address - cut out)> wrote:
>
> >HI,
> >I've got Windows XP Mode running on Wndows 7 Professional x64. I have an
> >instance of SQL 2008 running on Windows 7 which I would like my copy of
> >VS2010b2 Pro running in WinXPMode to see. However, I cannot figure out the
> >right combination of networking and firewall adjustments to make. Below is
> >what I've done so far. Can someone help me out with what I've left to do to
> >get this working?
> >
> >Thanks, Dan
> >
> >- Installed Loopback Adapter on Host OS
> >- Set up Loopback Adapter to have a static IP address 192.168.3.1 which the
> >VPC network adapter will use as its internet gateway.
> >- Configured the XP Mode Virtual Machine to use the loopback adapter.
> >- Gave the network connection in XP mode the static IP address 192.168.3.2.
> >and the default gateway as 192.168.3.1.
> >
> >At this point I can ping my host OS from my guest OS.
> >
> >- Added incoming rules to my Win7 firewall for port 1433/TCp and 1434/UDP
> >and also for sqlsrvr.exe
> >- Opened SQL Server Configuration Manager and Enabled Named Pipes and TCP/IP
> >for your SQL Server on my host OS
> >- Within properties for TCP/IP, added entry for IP 192.168.3.1 on port 1433
> >
> >However, I still cannot telnet to my host OS port 1433 or 1434 from within
> >my guest OS and have run out of ideas.
> .
>

Re: How do I get the guest OS to see a SQL server running on the h

Sent: 12/23/2009
From: Robert Comer <(email address - cut out)>
Message:

You're welcome, glad you got it going!

--
Bob Comer

On Wed, 23 Dec 2009 15:27:01 -0800, Dan Maharry
<(email address - cut out)> wrote:

Show quoted text

>Hi Robert,
>
>It was definitely the firewall that's the issue. Disabling the firewall had
>it connecting fine. By luck I seem to have got it working with the Firewall's
>troubleshooting wizard and telling it to open incoming connections for
>sqlservr.exe. Which worked for some reason although I don't know what it
>changed.
>
>Thansk for your help.
>
>Dan
>
>"Robert Comer" wrote:
>
>> To make sure it's a firewall issue, try disabling the firewall for the
>> loopback adapter, then you'll know if that's the problem.
>>
>> My guess is that you have a firewall zone problem, but the above will
>> tell you if it's the firewall at all that's the problem.
>>
>> Also, do you have more than one network adapter assigned to the VM?
>>
>> --
>> Bob Comer
>>
>>
>> On Tue, 22 Dec 2009 16:15:01 -0800, Dan Maharry
>> <(email address - cut out)> wrote:
>>
>> >HI,
>> >I've got Windows XP Mode running on Wndows 7 Professional x64. I have an
>> >instance of SQL 2008 running on Windows 7 which I would like my copy of
>> >VS2010b2 Pro running in WinXPMode to see. However, I cannot figure out the
>> >right combination of networking and firewall adjustments to make. Below is
>> >what I've done so far. Can someone help me out with what I've left to do to
>> >get this working?
>> >
>> >Thanks, Dan
>> >
>> >- Installed Loopback Adapter on Host OS
>> >- Set up Loopback Adapter to have a static IP address 192.168.3.1 which the
>> >VPC network adapter will use as its internet gateway.
>> >- Configured the XP Mode Virtual Machine to use the loopback adapter.
>> >- Gave the network connection in XP mode the static IP address 192.168.3.2.
>> >and the default gateway as 192.168.3.1.
>> >
>> >At this point I can ping my host OS from my guest OS.
>> >
>> >- Added incoming rules to my Win7 firewall for port 1433/TCp and 1434/UDP
>> >and also for sqlsrvr.exe
>> >- Opened SQL Server Configuration Manager and Enabled Named Pipes and TCP/IP
>> >for your SQL Server on my host OS
>> >- Within properties for TCP/IP, added entry for IP 192.168.3.1 on port 1433
>> >
>> >However, I still cannot telnet to my host OS port 1433 or 1434 from within
>> >my guest OS and have run out of ideas.
>> .
>>

Post Reply | This is Spam! | Mark as Spam

Other groups

Virtual PC (Mac)(3592)	Virtual PC(12844)	Virtual PC (French)(496)
Virtual Server 2005(6245)

Our Sponsors

Virtual Server 2005 Info Here!
http://www.aspdeveloper.net

Wiki

Blogs

Articles

Image galleries

File galleries

Forums

Maps

Directories

ASP Developer Network (since 1996) - Brought to you by Steve Radich and BitShop, Inc. - http://www.bitshop.com
Copyright © 1997-2005 by BitShop, Inc. All Rights Reserved.
No content may be reproduced in any form without written permission from BitShop, Inc.
We will be honored to assist with reproduction rights on our material if you contact us.
We also can provide print articles for your magazine, private training seminars at your site, and conference presentations.
Thank you for visiting. Please bookmark our site if you found it useful!
If you wish to make a donation it will help further the development of these free resources: