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

* Just looked at vmware esxi...why would I install this instead of v
* Trying To Recover XP Environment
* Trying to create a vhd of Vista64Ult on a computer running Vista64
* Drag & Drop
* Full Screen in Vista
* Mini newsgroup FAQ for the week of 8/24/2008
* Check Point VPN client on VPC
* Check Point FDE and VPC2k7
* Cannot get DOS program (1992 Foxpro) to work
* VPC MAC Addresses
* network driver for DOS VM
* Hardware Vitualization
* VPC 2007 installation problems
* Mouse Not Working in Local Virtual PC
* USB Ports
* Info on SOA, TOGAF, Virtualisation, SaaS etc.
* Virtual PC type app without admin rights?
* Disk is Full error
* Guest autologin and startup
* .wim to VHD

Add Solution

Vitual PC 2007 and SQL Server 2005 Express

Source: microsoft.public.virtualpc
Sent: 08/25/2008
From: Newby
Message:

Hi folks,

As a developer I have installed Virtual PC as Microsoft suggest its a better
solution than multi booting one PC.

I have a problem connecting to an SQL database on the host.

I can use and test Applications if I install SQL Server 2005 Express in each
of the VM's but keeping all the db's in sync is a real pain. When trying to
acces the Host db, all attempts fail to connect.

Yes I know I can install a database on another physical PC but thats not
always possible.

Has anyone got any suggestions on how to overcome this??

Thanks

Post Reply | This is Spam! | Mark as Spam

Related Messages

Re: Vitual PC 2007 and SQL Server 2005 Express

Sent: 08/25/2008
From: Steve Jain <(email address - cut out)>
Message:

On Mon, 25 Aug 2008 16:37:01 -0700, Newby
<(email address - cut out)> wrote:

Assuming that you've got network connectivity between the 2 it should
work. Need more info:
Host OS, VM OS?
Are you connected to a network? If so, what do you have selected for
networking options under the VM?
Have you set an exception in the firewall to let SQL out to the VM?
Can you ping the host PC from the VM?

--
Cheers,
Steve Jain, Virtual Machine MVP
http://vpc.essjae.com/
I do not work for Microsoft.

Show quoted text

>Hi folks,
>
>As a developer I have installed Virtual PC as Microsoft suggest its a better
>solution than multi booting one PC.
>
>I have a problem connecting to an SQL database on the host.
>
>I can use and test Applications if I install SQL Server 2005 Express in each
>of the VM's but keeping all the db's in sync is a real pain. When trying to
>acces the Host db, all attempts fail to connect.
>
>Yes I know I can install a database on another physical PC but thats not
>always possible.
>
>Has anyone got any suggestions on how to overcome this??
>
>Thanks

Re: Vitual PC 2007 and SQL Server 2005 Express

Sent: 08/25/2008
From: Newby
Message:

Hi Steve,

I can use either Windows Xp Pro SP2 or SP3, or Vista Premium as the host wth
the same result.
Yes I am connected to a network and I can Access SQL 2005 Servers elsewhere
on the network from the VM. Its just trying to keep it local that fails.
For the purpose of this exercise and resolving the issue, I've turned off
all firewalls. but still not working.

Host IP 192.168.1.100
VM IP 192.168.1.111
Can ping both ways without any problems

I'm not an MVP but been playing with Windows since 3.0 and this one has got
me stumped.

I used virtual machines for years as an IBM Mainframe VM Sysprog but doesn't
relate although I understand the principle.

I look forward to any pointers as I'm not ready to give up yet.

Thanks

Peter.
"Steve Jain" wrote:

Show quoted text

> On Mon, 25 Aug 2008 16:37:01 -0700, Newby
> <(email address - cut out)> wrote:
>
> >Hi folks,
> >
> >As a developer I have installed Virtual PC as Microsoft suggest its a better
> >solution than multi booting one PC.
> >
> >I have a problem connecting to an SQL database on the host.
> >
> >I can use and test Applications if I install SQL Server 2005 Express in each
> >of the VM's but keeping all the db's in sync is a real pain. When trying to
> >acces the Host db, all attempts fail to connect.
> >
> >Yes I know I can install a database on another physical PC but thats not
> >always possible.
> >
> >Has anyone got any suggestions on how to overcome this??
> >
> >Thanks
>
> Assuming that you've got network connectivity between the 2 it should
> work. Need more info:
> Host OS, VM OS?
> Are you connected to a network? If so, what do you have selected for
> networking options under the VM?
> Have you set an exception in the firewall to let SQL out to the VM?
> Can you ping the host PC from the VM?
>
> --
> Cheers,
> Steve Jain, Virtual Machine MVP
> http://vpc.essjae.com/
> I do not work for Microsoft.
>

Re: Vitual PC 2007 and SQL Server 2005 Express

Sent: 08/26/2008
From: Steve Jain <(email address - cut out)>
Message:

On Mon, 25 Aug 2008 20:03:02 -0700, Newby
<(email address - cut out)> wrote:

Can you you access any shares, i.e. \\hostPC?
Is the host x64 by chance, with 64bit SQL? I'm wondering if that is
the issue with the 32bit OS on the VM?

--
Cheers,
Steve Jain, Virtual Machine MVP
http://vpc.essjae.com/
I do not work for Microsoft.

Show quoted text

>Hi Steve,
>
>I can use either Windows Xp Pro SP2 or SP3, or Vista Premium as the host wth
>the same result.
> Yes I am connected to a network and I can Access SQL 2005 Servers elsewhere
>on the network from the VM. Its just trying to keep it local that fails.
>For the purpose of this exercise and resolving the issue, I've turned off
>all firewalls. but still not working.
>
>Host IP 192.168.1.100
>VM IP 192.168.1.111
>Can ping both ways without any problems
>
>I'm not an MVP but been playing with Windows since 3.0 and this one has got
>me stumped.
>
>I used virtual machines for years as an IBM Mainframe VM Sysprog but doesn't
>relate although I understand the principle.
>
>I look forward to any pointers as I'm not ready to give up yet.
>
>Thanks
>
>Peter.

Re: Vitual PC 2007 and SQL Server 2005 Express

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

Newby;819930 Wrote:

How have you got SQL2005 Express configured? What kind (if any) errors
are you getting when you attempt to connect to sql server? Did you
configure it to accept IP address or named pipes? What kind of account
access did you set up (Windows Auth. or SQL account)?

--
pweegar

Show quoted text

> Hi Steve,
>
> I can use either Windows Xp Pro SP2 or SP3, or Vista Premium as the
> host wth
> the same result.
> Yes I am connected to a network and I can Access SQL 2005 Servers
> elsewhere
> on the network from the VM. Its just trying to keep it local that
> fails.
> For the purpose of this exercise and resolving the issue, I've turned
> off
> all firewalls. but still not working.
>
> Host IP 192.168.1.100
> VM IP 192.168.1.111
> Can ping both ways without any problems
>
> I'm not an MVP but been playing with Windows since 3.0 and this one has
> got
> me stumped.
>
> I used virtual machines for years as an IBM Mainframe VM Sysprog but
> doesn't
> relate although I understand the principle.
>
> I look forward to any pointers as I'm not ready to give up yet.
>
> Thanks
>
> Peter.
> "Steve Jain" wrote:
> > > >
> > > On Mon, 25 Aug 2008 16:37:01 -0700, Newby
> > > <Newby@xxxxxx> wrote:
> > >> > > > >
> > > > >Hi folks,
> > > > >
> > > > >As a developer I have installed Virtual PC as Microsoft suggest its
> > > a better
> > > > >solution than multi booting one PC.
> > > > >
> > > > >I have a problem connecting to an SQL database on the host.
> > > > >
> > > > >I can use and test Applications if I install SQL Server 2005 Express
> > > in each
> > > > >of the VM's but keeping all the db's in sync is a real pain. When
> > > trying to
> > > > >acces the Host db, all attempts fail to connect.
> > > > >
> > > > >Yes I know I can install a database on another physical PC but thats
> > > not
> > > > >always possible.
> > > > >
> > > > >Has anyone got any suggestions on how to overcome this??
> > > > >
> > > > >Thanks> > > >
> > >
> > > Assuming that you've got network connectivity between the 2 it
> > should
> > > work. Need more info:
> > > Host OS, VM OS?
> > > Are you connected to a network? If so, what do you have selected
> > for
> > > networking options under the VM?
> > > Have you set an exception in the firewall to let SQL out to the
> > VM?
> > > Can you ping the host PC from the VM?
> > >
> > > --
> > > Cheers,
> > > Steve Jain, Virtual Machine MVP
> > > 'esSJae.com Virtual Machine Downloads' (http://vpc.essjae.com/)
> > > I do not work for Microsoft.
> > > > >

Re: Vitual PC 2007 and SQL Server 2005 Express

Sent: 09/04/2008
From: Newby
Message:

hi pweegar

Yes its all configured correctly. I use TCP IP for connections and its set
to support both local and remoted connections. The SQL server on the host (32
bit) can be accessed locally on the host and across the network from other
PCs so no probs there.

The VM can see shares available from other PCs on the network and can copy
to and from using them. It can also see shares on the host and access them so
networking is working just fine. The Host can also see and access the VM
Shares.

Suports mixed mode, both SQL auth and account. Neither works.

So now after checking everything and finding as above, as if by magic it now
works at least on one of the XP hosts (XP SP3). I'll try in on Vista Ultimate
and XP SP2.

Thanks

Peter

"pweegar" wrote:

Show quoted text

>
> Newby;819930 Wrote:
> > Hi Steve,
> >
> > I can use either Windows Xp Pro SP2 or SP3, or Vista Premium as the
> > host wth
> > the same result.
> > Yes I am connected to a network and I can Access SQL 2005 Servers
> > elsewhere
> > on the network from the VM. Its just trying to keep it local that
> > fails.
> > For the purpose of this exercise and resolving the issue, I've turned
> > off
> > all firewalls. but still not working.
> >
> > Host IP 192.168.1.100
> > VM IP 192.168.1.111
> > Can ping both ways without any problems
> >
> > I'm not an MVP but been playing with Windows since 3.0 and this one has
> > got
> > me stumped.
> >
> > I used virtual machines for years as an IBM Mainframe VM Sysprog but
> > doesn't
> > relate although I understand the principle.
> >
> > I look forward to any pointers as I'm not ready to give up yet.
> >
> > Thanks
> >
> > Peter.
> > "Steve Jain" wrote:
> > > > >
> > > > On Mon, 25 Aug 2008 16:37:01 -0700, Newby
> > > > <Newby@xxxxxx> wrote:
> > > >> > > > >
> > > > > >Hi folks,
> > > > > >
> > > > > >As a developer I have installed Virtual PC as Microsoft suggest its
> > > > a better
> > > > > >solution than multi booting one PC.
> > > > > >
> > > > > >I have a problem connecting to an SQL database on the host.
> > > > > >
> > > > > >I can use and test Applications if I install SQL Server 2005 Express
> > > > in each
> > > > > >of the VM's but keeping all the db's in sync is a real pain. When
> > > > trying to
> > > > > >acces the Host db, all attempts fail to connect.
> > > > > >
> > > > > >Yes I know I can install a database on another physical PC but thats
> > > > not
> > > > > >always possible.
> > > > > >
> > > > > >Has anyone got any suggestions on how to overcome this??
> > > > > >
> > > > > >Thanks> > > >
> > > >
> > > > Assuming that you've got network connectivity between the 2 it
> > > should
> > > > work. Need more info:
> > > > Host OS, VM OS?
> > > > Are you connected to a network? If so, what do you have selected
> > > for
> > > > networking options under the VM?
> > > > Have you set an exception in the firewall to let SQL out to the
> > > VM?
> > > > Can you ping the host PC from the VM?
> > > >
> > > > --
> > > > Cheers,
> > > > Steve Jain, Virtual Machine MVP
> > > > 'esSJae.com Virtual Machine Downloads' (http://vpc.essjae.com/)
> > > > I do not work for Microsoft.
> > > > > >
>
> How have you got SQL2005 Express configured? What kind (if any) errors
> are you getting when you attempt to connect to sql server? Did you
> configure it to accept IP address or named pipes? What kind of account
> access did you set up (Windows Auth. or SQL account)?
>
>
> --
> pweegar
>

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: