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

* Virtual PC with Pervasive SQL 2000i
* Virtual HDs and Physical HDs...
* Installing Linux Ubuntu
* Setting hard disk ID
* Server 2003 Ctr+Alt+Del Problem
* WDS and Virtual PC "No Images Available"
* virtual PC-Windows Activation
* Mini newsgroup FAQ for the week of 10/5/2008
* Red Hat Linux
* Print Still not working
* ATI TV Wonder Pro A/V Capture
* Cap Lock Button
* Virtual Hard Disk
* Create a VHD Image of my laptop
* Recovery of Forgot Password for Login
* Can Virtual PC and Virtual Server Run On the Same Host At The Same Time?
* Cloning Virtual Machines -- How To Change The License Key
* VPC Additions in Safe Mode on Vista?
* Ballmer says Microsoft can survive crisis
* CPU usage in minimized Virtual PC?

Add Solution

VPC and SQL Connectivity

Source: microsoft.public.virtualpc
Sent: 10/07/2008
From: Ed
Message:

I have created a windows 2003 server
as a Virtual (guest) Machine, using Virtual PC.
I have Windows XP as the host OS.
I have installed SQL Server 2000 on the
Win 2000 server. I have installed SQL Client utilities on the
host machine. I created a loopback adapter
on the host, and I am able to ping the guest
from the Host and the host from the guest.
Using the SQL client configuration utility, I have
added the guests ip and sql port address on the host.
I have windows firewall turned off on both guest and host machines.
But I am not able to query the SQL database on the guest from the host
I get a message that I am unable to connect to SQL Server.
Any suggestions on how to get SQL Query Analyser to "See"
the SQL installation on the guest.

Thanks in advance...Ed

Post Reply | This is Spam! | Mark as Spam

Related Messages

Re: VPC and SQL Connectivity

Sent: 10/08/2008
From: "Bob Campbell" <(email address - cut out)>
Message:

"Ed" <(email address - cut out)am> wrote in message
news:(email address - cut out)...

Being able to PING is not enough. Can you copy files in either (preferably
both) directions? Can you see shared drives on both? You really need to
have full networking going between the host and guest. The loopback
adapter may not be enough, or it may be wired incorrectly.

Is this a single machine, not on network? If it is on a network already,
then just establish normal networking between host and guest.

Is the SQL service actually running on the guest? Can you do queries on
the guest?

Show quoted text

>I have created a windows 2003 server
> as a Virtual (guest) Machine, using Virtual PC.
> I have Windows XP as the host OS.
> I have installed SQL Server 2000 on the
> Win 2000 server. I have installed SQL Client utilities on the
> host machine. I created a loopback adapter
> on the host, and I am able to ping the guest
> from the Host and the host from the guest.
> Using the SQL client configuration utility, I have
> added the guests ip and sql port address on the host.
> I have windows firewall turned off on both guest and host machines.
> But I am not able to query the SQL database on the guest from the host
> I get a message that I am unable to connect to SQL Server.
> Any suggestions on how to get SQL Query Analyser to "See"
> the SQL installation on the guest.

Re: VPC and SQL Connectivity

Sent: 10/10/2008
From: Ed
Message:

I tried creating shares on both host and guest.
I can copy from the host to the guest, but not from
the quest to the host. When copying from the host to the guest,
authentication is required. When copying from the guest to the
host, I try to authenticate, but it keeps disabling the account.
I have tried resetting the password a lot of times but it does not help.
Caps Lock and Num Lock are off when I type the password.

You ask "Is this a single machine, not on a network". Do you mean
the company LAN, or a virtual network between the host and guest?
This computer can be connected to the company LAN., But I do not want the
guest machine to be visible on the company LAN. So far it is not. I want the
host to "see" the guest. But I do not want other clients on the company
LAN to see the guest.

Thank in advance...Ed

--
Ed

"Bob Campbell" wrote:

Show quoted text

> "Ed" <(email address - cut out)am> wrote in message
> news:(email address - cut out)...
> >I have created a windows 2003 server
> > as a Virtual (guest) Machine, using Virtual PC.
> > I have Windows XP as the host OS.
> > I have installed SQL Server 2000 on the
> > Win 2000 server. I have installed SQL Client utilities on the
> > host machine. I created a loopback adapter
> > on the host, and I am able to ping the guest
> > from the Host and the host from the guest.
> > Using the SQL client configuration utility, I have
> > added the guests ip and sql port address on the host.
> > I have windows firewall turned off on both guest and host machines.
> > But I am not able to query the SQL database on the guest from the host
> > I get a message that I am unable to connect to SQL Server.
> > Any suggestions on how to get SQL Query Analyser to "See"
> > the SQL installation on the guest.
>
> Being able to PING is not enough. Can you copy files in either (preferably
> both) directions? Can you see shared drives on both? You really need to
> have full networking going between the host and guest. The loopback
> adapter may not be enough, or it may be wired incorrectly.
>
> Is this a single machine, not on network? If it is on a network already,
> then just establish normal networking between host and guest.
>
> Is the SQL service actually running on the guest? Can you do queries on
> the guest?
>
>

Re: VPC and SQL Connectivity

Sent: 10/10/2008
From: "Bob Campbell" <(email address - cut out)>
Message:

"Ed" <(email address - cut out)am> wrote in message
news:(email address - cut out)...

If the host machine is on the company LAN, are you a Local Admin on the
machine? Are you allowed to create your own accounts?

Then you should use the Shared Networking (NAT) networking option for the
guest, connect the host to the LAN and forget the Loopback adapter. This
will make the guest invisible to the LAN, but visible to the host. The
guest will still be able see the LAN, however, and (for example) get
Internet access thru the LAN if your host machine has it. But as far as
the LAN is concerned, all network packets will coming from/going to the host
machine.

FWIW, I do this everyday. I have Server 2003 with SQL Server 2005 running
in VPC on this Vista box. I am not using the NAT networking however,
because I need other machines on the LAN to see the SQL Server.

Show quoted text

>I tried creating shares on both host and guest.
> I can copy from the host to the guest, but not from
> the quest to the host. When copying from the host to the guest,
> authentication is required. When copying from the guest to the
> host, I try to authenticate, but it keeps disabling the account.
> I have tried resetting the password a lot of times but it does not help.
> Caps Lock and Num Lock are off when I type the password.
> You ask "Is this a single machine, not on a network". Do you mean
> the company LAN, or a virtual network between the host and guest?
> This computer can be connected to the company LAN., But I do not want the
> guest machine to be visible on the company LAN. So far it is not. I want
> the
> host to "see" the guest. But I do not want other clients on the company
> LAN to see the guest.
>
> Thank in advance...Ed

Re: VPC and SQL Connectivity

Sent: 10/16/2008
From: pweegar <(email address - cut out)>
Message:

What is the excat error message you are getting? Is the error bein
caused by an ip addres, named pipes, etc

--
pweegar

Re: VPC and SQL Connectivity

Sent: 10/20/2008
From: Ed
Message:

I tried just changing to Shared Networking (NAT), and now I can no longer ping
the quest. Should the guest's ip address change now? And if Yes to what?

Ed

"Bob Campbell" wrote:

Show quoted text

> "Ed" <(email address - cut out)am> wrote in message
> news:(email address - cut out)...
> >I tried creating shares on both host and guest.
> > I can copy from the host to the guest, but not from
> > the quest to the host. When copying from the host to the guest,
> > authentication is required. When copying from the guest to the
> > host, I try to authenticate, but it keeps disabling the account.
> > I have tried resetting the password a lot of times but it does not help.
> > Caps Lock and Num Lock are off when I type the password.
>
> If the host machine is on the company LAN, are you a Local Admin on the
> machine? Are you allowed to create your own accounts?
>
> > You ask "Is this a single machine, not on a network". Do you mean
> > the company LAN, or a virtual network between the host and guest?
> > This computer can be connected to the company LAN., But I do not want the
> > guest machine to be visible on the company LAN. So far it is not. I want
> > the
> > host to "see" the guest. But I do not want other clients on the company
> > LAN to see the guest.
> >
> > Thank in advance...Ed
>
> Then you should use the Shared Networking (NAT) networking option for the
> guest, connect the host to the LAN and forget the Loopback adapter. This
> will make the guest invisible to the LAN, but visible to the host. The
> guest will still be able see the LAN, however, and (for example) get
> Internet access thru the LAN if your host machine has it. But as far as
> the LAN is concerned, all network packets will coming from/going to the host
> machine.
>
> FWIW, I do this everyday. I have Server 2003 with SQL Server 2005 running
> in VPC on this Vista box. I am not using the NAT networking however,
> because I need other machines on the LAN to see the SQL Server.
>
>

Re: VPC and SQL Connectivity

Sent: 10/21/2008
From: "Bill Grant" <not.available@online>
Message:

Shared Networking (NAT) does not support guest to host networking. It
does give the guest access to the physical network.

The IP address of the guest should change. Shared networking is very
similar to ICS and the guest should get its network config from a DHCP-style
allocator in the host (if it is set to get an IP automatically).

"Ed" <(email address - cut out)am> wrote in message
news:(email address - cut out)...

Show quoted text

> I tried just changing to Shared Networking (NAT), and now I can no longer
> ping
> the quest. Should the guest's ip address change now? And if Yes to what?
>
>
> Ed
>
>
> "Bob Campbell" wrote:
>
>> "Ed" <(email address - cut out)am> wrote in message
>> news:(email address - cut out)...
>> >I tried creating shares on both host and guest.
>> > I can copy from the host to the guest, but not from
>> > the quest to the host. When copying from the host to the guest,
>> > authentication is required. When copying from the guest to the
>> > host, I try to authenticate, but it keeps disabling the account.
>> > I have tried resetting the password a lot of times but it does not
>> > help.
>> > Caps Lock and Num Lock are off when I type the password.
>>
>> If the host machine is on the company LAN, are you a Local Admin on the
>> machine? Are you allowed to create your own accounts?
>>
>> > You ask "Is this a single machine, not on a network". Do you mean
>> > the company LAN, or a virtual network between the host and guest?
>> > This computer can be connected to the company LAN., But I do not want
>> > the
>> > guest machine to be visible on the company LAN. So far it is not. I
>> > want
>> > the
>> > host to "see" the guest. But I do not want other clients on the
>> > company
>> > LAN to see the guest.
>> >
>> > Thank in advance...Ed
>>
>> Then you should use the Shared Networking (NAT) networking option for the
>> guest, connect the host to the LAN and forget the Loopback adapter.
>> This
>> will make the guest invisible to the LAN, but visible to the host. The
>> guest will still be able see the LAN, however, and (for example) get
>> Internet access thru the LAN if your host machine has it. But as far as
>> the LAN is concerned, all network packets will coming from/going to the
>> host
>> machine.
>>
>> FWIW, I do this everyday. I have Server 2003 with SQL Server 2005
>> running
>> in VPC on this Vista box. I am not using the NAT networking however,
>> because I need other machines on the LAN to see the SQL Server.
>>
>>

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: