During install I am running a SQL script to create a database. I want to have the database reside in a folder that IS will install on the user's machine.
So for instance, I want it to install at \DB
When IS runs the SQL script, I get the following error.
Error 27506.Error executing SQL script sqlscript.sql. Line 49. CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'c:\path\to\dir\data.mdf'.(5123)
I'm assuming that until IS is done running, any folders it creates are read-only. As such, I can't create the DB where I want.
Does anyone know a work around for this?
I should also note, that if I tell my script to create the DB in a DIR that IS is not creating, it works fine.
Do you correctly specifiy the path of a database file that you attempt to create in your SQL script? I am assuming that you want to create it under C:\Program Files\Leo Software\Leo\DB folder, but the error message is stating 'c:\path\to\dir\data.mdf'.
It seems an issue or limitation of Microsoft SQL Server 2005 Express Edition. The behaivor is reproduced (even if you run the same script from Microsoft SQL Server Management Studio) when you specify any path containing one or more space characters for a database file in the CREATE DATABASE statement. It is working with Enterprise Edition. One workaround I can think of is to copy your database file to the target machine and call sp_attach_db stored procedure in order to create the database.
