I have created a merge module using Wix v3 that successfully installs several databases in to SQL Express 2005 SP3 when integrated in to a Wix generated MSI of my own making. However, when I ship this merge module to my customer, he integrates it into an InstallShield Setup program and it generates the following error message in the resulting log:
MSI (s) (F0:9C) [15:21:04:995]: Executing op: ActionStart(Name=CreateDatabase,Description=Creating Databases,) MSI (s) (F0:9C) [15:21:04:995]: Executing op: CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********) MSI (s) (F0:F0) [15:21:05:011]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI4F0.tmp, Entrypoint: CreateDatabase CreateDatabase: Error 0x80004005: failed to create to database: 'LeicaSCN', error: unknown error MSI (s) (F0!50) [15:21:25:386]: Product: Slide Scanner Database -- Error 26201.Error -2147467259: failed to create SQL database: LeicaSCN, error detail: unknown error. I include a fragment of the XML for the database creation below: <?xml version="1.0" encoding="UTF-8"?> <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"; xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension";> <?include Includes.wxi?> <Fragment Id="SqlLeicaSCNFragment"> <DirectoryRef Id="TARGETDIR"> <Component Id='_SqlLeicaSCNDB' Guid='3A6552CE-FA44-4F86-8ADC-8671963D9E80' KeyPath='yes' Win64='$(var.Win64YesNo)'> <sql:SqlDatabase Id='SqlLeicaSCNDB' Database='LeicaSCN' Server='[SQLSERVER]' CreateOnInstall='yes' DropOnUninstall='no' ContinueOnError='no'> <sql:SqlScript Id='__DtCreateTables' BinaryKey='_Dt1' ExecuteOnInstall='yes' /> <sql:SqlScript Id='__DffnBoolean' BinaryKey='_Df1' ExecuteOnInstall='yes' /> <sql:SqlScript Id='__DffnCleanDefaultValue' BinaryKey='_Df2' ExecuteOnInstall='yes' /> Could it be that I need to supply the 'User' attribute to the sql:Database element as searching the internet seems to mention that the 0x80004005 error may be related to user credentials or account role/membership? I ask as the WiX tutorial part 7.1 does use this attribute, but the schema states that its use is optional. If the answer is yes, then given that I normally logon to SQL Express using Windows Authentication rather that SQL Server Authentication, is the user name and password my Windows logon details, or are these details only used for SQL Server Authentication? If not related to user credentials, what else might be causing my error? Many thanks for any help. We have been struggling with this problem for several days now. -- View this message in context: http://n2.nabble.com/Help%3A-%27Error-26201.Error--2147467259%3A-failed-to-create-SQL-database%27-tp3314870p3314870.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
