Ug. Can you try the SQL Profiler and see if more information about the error is available via that thing?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Shurts Sent: Friday, May 30, 2008 06:48 To: wix-users@lists.sourceforge.net Subject: [WiX-users] Problem with CreateDatabase 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
