I tried searching on Google and not much is coming back. If anyone could
help, I would appreciate it greatly.
WiX Version Info:
Microsoft (R) Windows Installer Xml Compiler version 3.0.3617.0
Snippet from my project file:
<Component Id="C_SQL_AutoFind6SQL"
Guid="{00BEED5F-A8BD-421B-87D0-4A977EE08B95}">
<sql:SqlDatabase Id="CreateAutoFind6DBSQL" ConfirmOverwrite="no"
ContinueOnError="no" DropOnUninstall="yes"
CreateOnInstall="yes" Database="AutoFind6"
Server="[AFSQLSERVER]" Instance="[AFSQLSERVERINSTANCE]">
<sql:SqlString Id="DropAFLogin" ContinueOnError="yes"
ExecuteOnInstall="no" ExecuteOnUninstall="yes" RollbackOnInstall="yes"
SQL="DROP LOGIN [AFDBUSER]" Sequence="1" />
<sql:SqlString Id="DropReportLogin" ContinueOnError="yes"
ExecuteOnInstall="no" ExecuteOnUninstall="yes" RollbackOnInstall="yes"
SQL="DROP LOGIN [REPORTDBUSER]" Sequence="2" />
<sql:SqlString Id="AddLoginSQLAF6" ContinueOnError="no"
ExecuteOnInstall="yes" Sequence="3"
SQL="CREATE LOGIN [AFDBUSER] WITH
PASSWORD='[AFDBPASSWORD]'; CREATE USER [AFDBUSER] FOR LOGIN [AFDBUSER];" />
<sql:SqlString Id="AddRoleSQLAF6" ContinueOnError="no"
ExecuteOnInstall="yes" Sequence="5" SQL="EXEC sp_addrolemember 'db_owner',
'[AFDBUSER]'" />
<sql:SqlString Id="AddLoginSQLReport" ContinueOnError="no"
ExecuteOnInstall="yes" Sequence="6"
SQL="CREATE LOGIN [REPORTDBUSER] WITH
PASSWORD='[REPORTDBPASS]'; CREATE USER [REPORTDBUSER] FOR LOGIN
[REPORTDBUSER];" />
<?if $(var.SQLEncryption.Configuration) = Debug ?>
<sql:SqlScript Id="DbInitSql" BinaryKey="DBSetup"
ContinueOnError="no" ExecuteOnInstall="yes" Sequence="8" />
<?endif ?>
</sql:SqlDatabase>
<Condition>SQLAUTHTYPE ~= "SQL"</Condition>
</Component>
Error in the log:
MSI (s) (80:E4) [06:39:36:734]: Executing op:
ActionStart(Name=CreateDatabase,Description=Creating Databases,)
Action 6:39:36: CreateDatabase. Creating Databases
MSI (s) (80:E4) [06:39:36:734]: Executing op:
CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (80:38) [06:39:36:750]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI1B5.tmp, Entrypoint: CreateDatabase
CreateDatabase: Error 0x80004005: failed to create to database:
'AutoFind6', error: unknown error
//aj
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
