SQL 2005 Creating Database in Vista

[pidge45]

Hi I am trying to create a new database using SQL Server 05 and I keep getting this error message:

Msg 5133, Level 16, State 1, Line 1

Directory lookup for the file "J:\Sales_Data\SalesPrimary.mdf" failed with the operating system error 3(error not found).

Msg 1802, Level 16, State 1, Line 1

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

I have created the volumes J,K and L and I have created the folder Sales_Data in each but it appears SQL just can't see them? I used exactly the same statement on my old pc using XP Pro with no trouble so I am wondering either what I am doing wrong or if it is a Vista issue. This is the statement I am using:

CREATE DATABASE Sales

ON

PRIMARY

(NAME = SalesPrimary,

FILENAME = 'J:\Sales_Data\SalesPrimary.mdf',

SIZE = 50MB,

MAXSIZE = 200,

FILEGROWTH = 20),

FILEGROUP SalesFG

(NAME = SalesData1,

FILENAME = 'K:\Sales_Data\SalesData1.ndf',

SIZE = 200MB,

MAXSIZE = 800,

FILEGROWTH = 100),

( NAME = SalesData2,

FILENAME = 'K:\Sales_Data\SalesData2.ndf',

SIZE = 400MB,

MAXSIZE = 1200,

FILEGROWTH = 300),

FILEGROUP SalesHistoryFG

(NAME = SalesHistory1,

FILENAME = 'K:\Sales_Data\SalesHistory1.ndf',

SIZE = 100MB,

MAXSIZE = 500,

FILEGROWTH = 50)

LOG ON

(Name = Archlog1,

FILENAME = 'L:\Sales_Data\SalesLog.ldf',

SIZE = 300MB,

MAXSIZE = 800,

FILEGROWTH = 100)

The folders have enough room and I have full permissions on the pc. Any help anyone can give me would be very much appreciated.

[ɹəuəllıʍ ʇɐb]

I do not have any experience with Vista, so I can't tell you if it is related to Vista.

Can you manually create files on your J, K, and L drives?

Can you check the Event Viewer (if there is such a thing in Vista) if there are any more detailed information for the time when it happened?