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:
Quote:
> "ronald" <ronald@xxxxxx> wrote in message
> news:2BD42B74-92D2-4401-8841-72197CDE078F@xxxxxx
> Quote:
> > 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 VMs as the development
> > environment
> > tools get updated over time.
>
> 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
> Quote:
> > 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.
>
> 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
>
>