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

"ronald" <ronald@xxxxxx> wrote in message
news:2BD42B74-92D2-4401-8841-72197CDE078F@xxxxxx
I have just tried to do the following:

1) Mapped a Z:\ drive pointing to another machine on my network

2) Launched SQL Server 2008 Management Studio

3) Started the "Create new database" wizard

4) Clicked on the Browse (...) button to select the new databases data and
log files - only the local drives were available, not the mapped Z:\ drive

5) Altered the location of the new database and log files manually to point
at the mapped Z:\ drive - this produced SQL Server error: 5133 "CREATE
DATABASE failed. Some filenames listed could not be created. Check related
errors."

Turns out that SQL Server doesn't support mapped drives by default because
of the massive degredation in performance. There is a trace flag which you
can enable which allows this, but Microsoft don't recommend it:
http://support.microsoft.com/kb/304261
Exactly the same as you would on a physical machine - just make sure that
the VM's network adaptor is pointing at your host's physical NIC and not
e.g. NAT or Local Only...


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

Thanks, I finally got it - I had to turn on File Sharing on my guest vm (I
wrongly thought this setting was only to share files FROM my guest vm) and
once I did this I could see my host and map a drive.

Thanks for everyone's help - I learned a lot from ya'll and this experience.



"Mark Rae [MVP]" wrote: