none
Create Database on a Virtual Drive (Created with subst) Failed

    Question

  • When I try to add a (SQL Server 2005 Express Edition) database to my project (I'v tried a windows application and an ASP.NET application) in Visual Studio 2005 Professional Edition; It fails with an error like this :
    "create database failed. some file names listed could not be created (...)"
    but when I open the project from the real path It works.
    Is this a bug? Is there any solution? (In many situations there is a need for working with virtual drives. There must be some work around ...)

    Thanks
    Saturday, May 26, 2007 12:14 PM

Answers

  • SQL Server does not recognize OS level 'mapped' drives.

     

    You must use a 'actual' drive, or a SAN/NAS lun(drive).

    Saturday, May 26, 2007 3:32 PM