Vista - Does SQL Server 2008 run in Virtual PC 2007 SP1?

I assume that SQL Server 2008 (Standard Edition) will run, in Virtual PC 2007
SP1 (on a development machine), but I did not see that specifically stated in
the SQL Server installation notes.

Does anyone know for sure or not if SQL Server 2008 will run in Virtual PC
2007 SP1?

"ronald" <ronald@xxxxxx> wrote in message
news:320AE2F4-CCE7-42D3-9DE1-B6CEF9998BE9@xxxxxx
I can't be 100% certain about the Standard Edition, but I have installed the
Developer Edition in a VM with no problems...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

On Tue, 30 Dec 2008 13:19:39 -0800, ronald
<ronald@xxxxxx> wrote:
It really does not run on VPC2007SP1 itself at all....

Instead it runs in a guest operating system (XP, Vista, Win2003 etc)
installed in a virtual machine running under VPC2007....

The virtualization software used is less of a detail than the
operating system you want to install SQLServer into.

--

Bo Berglund (Sweden)

You are correct Bo - I improperly stated the question. Here is a redefined
question:

I have a Vista Ultimate SP1 guest OS in VPC 2007 SP1. I have shared folders
with the Host (also Vista Ultimate SP1). During the install of SQL Server
2008, I pointed the data directories to the shared folders and got an error.
I changed the data directories to folders within the guest virtual machine,
and the installation is proceeding. Is this just a bug in the installation
program or will SQL Server running in a guest VM not be able to use shared
folders?

"Bo Berglund" wrote:

"ronald" <ronald@xxxxxx> wrote in message
news:3A40141D-2866-4408-BA5E-C862571253B5@xxxxxx
When posting to a technical newsgroup asking for help because you "got an
error", it's *REALLY* useful to the people who are trying to help you if you
actually say what the error message was...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

The error message was:

The drive X:\ specified in directory X:\Database\dbs\data is not a valid
drive.

I used the VPC Shared drive functionality to map X:\ to my host C:\Database
folder.




"Mark Rae [MVP]" wrote:

How do you regular Windows networking inside of VPC guest to map a drive to
the host? In Windows Explorer when I expand Network, I see the VPC guest
(itself) and 2 other workstaitons in my WorkGroup, but do not see the host
machine listed. I have shared a couple of folders on the host, how do I map
a drive or create a network place inside of my VPC guest?



"Bob Campbell" wrote:

If you have Vista installed as a guest OS, why do you need access to the
SQL server from the host?

Forget about the host machine and concentrate on your vms. Set up the
2008 Server as your SQL server and use your vm clients to access it. The
host does not need to be part of the network. It just runs the vms.

"ronald" <ronald@xxxxxx> wrote in message
news:0BD25EC0-2DB3-433D-9AEA-B97EED01F44B@xxxxxx

I am setting up a development environment (SQL Server, etc.) in a guest vm
and want to store all my souce code and databases on the host so that my data
is always on the host as I add new guest vm's as the development environment
tools get updated over time.

It has been suggested to use regular Windows networking on the guest to
access a shared folder on the host (instead of VPC Shared Folders), but I am
not sure how to do this.

"Bill Grant" wrote:

"ronald" <ronald@xxxxxx> wrote in message
news:A97F4714-CA20-4F04-8C96-6123B9944FFE@xxxxxx

[top-posting corrected]
Firstly, I'm not certain whether SQL Server allows its data directory to
reside on remote disks - it certainly doesn't for its backup directory...

Secondly, shared drives are not 100% reliable - I'd suggest using standard
networking instead...


--
Mark Rae
ASP.NET MVP
http://www.markrae.net