Nevermind Rob, it was my kooky test machine. There have been no changes to
the machine that I am aware of, but now my SQL installs don't work. They
work on my other machines and VMs though. One day it was fine, next it
wasn't :-(
It just sucks because I have to move my BVTs to another machine. Okay,
enough of my whining.
//a
On Mon, Jun 2, 2008 at 12:11 AM, Rob Mensching <[EMAIL PROTECTED]>
wrote:
> 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
