I have resolved the problem by moving the sqldatabase element outside of a
component. By doing that it the installer is not trying to create the
database (I have a script for that) and I no longer need a until:user and
the installer seems to be using the current user to run the SQL scripts.
Here is my code...
<sql:SqlDatabase Id="SqlDatabase" Database="master" Server="localhost"
Instance="MVSQLEXPRESS" />
<DirectoryRef Id="SERVER">
<Component Id='Server.exe'
Guid='8027388d-0f90-465b-9668-d1388977caaa'>
<File Id='Server.exe' Source='C:\VS
Publish\ProgramFiles\Server\Server.exe' KeyPath='yes'/>
<ServiceInstall
Id="ServiceInstaller"
Type="ownProcess"
Name="Service"
DisplayName="Media and Licensing Service"
Description="Provides media distribution"
Start="auto"
Account="[SERVICEACCOUNT]"
Password="[SERVICEPASSWORD]"
ErrorControl="normal"
/>
<ServiceControl Id="StartService" Start="install" Stop="both"
Remove="uninstall" Name="Service" Wait="yes" />
<sql:SqlScript Id="CreateDatabase" ExecuteOnInstall="yes"
BinaryKey="CreateDatabaseSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="CreateUsers" ExecuteOnInstall="yes"
BinaryKey="CreateUsersSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="CreateBaseLineDb" ExecuteOnInstall="yes"
BinaryKey="CreateBaseLineDbSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="RemoveOldContent" ExecuteOnInstall="yes"
BinaryKey="RemoveOldContentSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="Upgrade" ExecuteOnInstall="yes"
BinaryKey="UpgradeSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="AddCompleteMedia" ExecuteOnInstall="yes"
BinaryKey="AddCompleteMediaSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="InstallContent" ExecuteOnInstall="yes"
BinaryKey="InstallContentSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="UpdateCustomPlayList" ExecuteOnInstall="yes"
BinaryKey="UpdateCustomPlayListSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="InstallFeaturedContent" ExecuteOnInstall="yes"
BinaryKey="InstallFeaturedContentSql" SqlDb="SqlDatabase"/>
</Component>
Thanks for the help!!
Gary
--
View this message in context:
http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp7596243p7596259.html
Sent from the wix-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
WiX-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users
