Attach database in Windows Vista

[dhouse]

Hi,
I am using IA7 to create an installer that needs to attach sql database to sql express. The installer works well in Windows 2003 and XP Prof but the database fails to attach in Windows Vista.

Below is the sql script that i use:

USE [master]
GO
CREATE DATABASE [TEST] ON
( FILENAME = N'$TARGETDIR$\\DataFiles\\EEMS2007.mdf' ),
( FILENAME = N'$TARGETDIR$\\DataFiles\\EEMS2007_Log.ldf' )
FOR ATTACH
GO

Is there any advise from the IA team?

[Gizm0]

Verify that the MSSQL.1 (default instance folder) is accessible from the user you're trying to make the attach.

[dhouse]

The data files are created on the $TARGETDIR$\\DataFiles\\ and not the default locations (which i am not sure how can it be done). I have assigned Everyone to Read and Write permission to this folder $TARGETDIR$\\DataFiles.

I can manually attached the files using SQL studio management express. Is there anything else that i miss out?