Vista - Vitual PC 2007 and SQL Server 2005 Express

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

On Mon, 25 Aug 2008 16:37:01 -0700, Newby
<Newby@xxxxxx> 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.

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 20:03:02 -0700, Newby
<Newby@xxxxxx> 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.

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)?