Thanks for the reply!
After looking at the verbose log I didn't see where the database was being
created so I removed the condition and changed the SQLDatabase to use 'sa'
with a password. I'm now receiving errors when the database is being
created...
Action 12:18:29: CreateDatabase. Creating Databases
MSI (s) (C4:6C) [12:18:29:608]: Executing op:
CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (C4:C0) [12:18:29:624]: Invoking remote custom action. DLL:
C:\Windows\Installer\MSI66CF.tmp, Entrypoint: CreateDatabase
CreateDatabase: Error 0x80004005: failed to create to database: 'mvdb',
error: unknown error
Error 26201. Error -2147467259: failed to create SQL database: mvdb, error
detail: unknown error.
MSI (s) (C4!E4) [12:18:57:695]: Product: Guru Teach Server Installation --
Error 26201. Error -2147467259: failed to create SQL database: mvdb, error
detail: unknown error.
CustomAction CreateDatabase returned actual error code 1603 (note this may
not be 100% accurate if translation happened inside sandbox)
Action ended 12:18:57: InstallFinalize. Return value 3.
The product.was now looks like this...
<util:User Id='SQLUser' Name='sa' Password='********' />
<Component Id='SqlComponent' Guid='A60B1852-7C4B-402B-A619-EECA2893C5AC'
KeyPath='yes'>
<sql:SqlDatabase Id='SqlDatabase' Database='mvdb'
Server='MVSQLEXPRESS' User='SQLUser' CreateOnInstall='yes'
DropOnUninstall='no' ContinueOnError='no'/>
<sql:SqlScript Id="CreateUsers" ExecuteOnInstall="yes"
BinaryKey="CreateUsersSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="CreateBaseLineDb" ExecuteOnInstall="yes"
BinaryKey="CreateBaseLineDbSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="RemoveOldGuruContent" ExecuteOnInstall="yes"
BinaryKey="RemoveOldGuruContentSql" 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="InstallGuruContent" ExecuteOnInstall="yes"
BinaryKey="InstallGuruContentSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="UpdateCustomPlayList" ExecuteOnInstall="yes"
BinaryKey="UpdateCustomPlayListSql" SqlDb="SqlDatabase"/>
<sql:SqlScript Id="InstallFeaturedContent" ExecuteOnInstall="yes"
BinaryKey="InstallFeaturedContentSql" SqlDb="SqlDatabase"/>
</Component>
I have installed SQL Management Studio on my test machine. After the
installation I logged on using the 'sa' user and manually created the mvdb
database without a problem.
I have also uploaded the complete verbose log but I don't see anything else
that could be the cause of the problem.
Thanks,
Gary
serverinstall.log
<http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/file/n7597803/serverinstall.log>
--
View this message in context:
http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-database-does-not-exist-when-executing-ExecuteSQLStrings-tp7597477p7597803.html
Sent from the wix-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
