I have created a WIX installer that installs a service and creates a SQL Server
database. I would like to have the database created in the a subfolder under
the main folder that the service is in. I have this working as long as the user
doesn't take the installer default for the install location. The default
folder from the installer is to have a subfolder created under the "Program
Files" folder. Evidently SQL Server doesn't have permission to create a
database anywhere under the "Program Files" or "Program Files (x86)" folders.
It appears that the Program Files folders have special permissions on them that
don't allow Sql Server to create a DB there.
Error that I receive from trying to create a database from the installer or
using Sql Server Studio
CREATE FILE encountered operating system error 5(Access is denied.) while
attempting to open or create the physical file
Code that is creating the DB:
<sql:SqlDatabase
Id="AbcDatabase"
Database="AbcDataBase"
Server="[DB_SERVER]"
ConfirmOverwrite="yes"
ContinueOnError="no"
CreateOnInstall="yes"
CreateOnReinstall="yes"
CreateOnUninstall="no"
DropOnReinstall="no"
DropOnInstall="no"
DropOnUninstall="no">
<sql:SqlFileSpec Name="DataBaseFile" Id ="mdfFile" Filename =
"[DB_DIR]AbcDataBase.mdf"/>
<sql:SqlLogFileSpec Name="DataBaseLogFile" Id ="ldfFile" Filename =
"[DB_DIR]AbcDataBase_Log.ldf"/>
</sql:SqlDatabase
Can anyone provide any guidance on how I can resolve this? It seems a bit out
of the norm to tell users that they can't install this in either of those
directories.
Thanks.
Jack
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
WiX-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users
