John, Firstly what value is the property SQLSERVER being set to, and where is it set?
If that is okay, then i suspect it is a SQL Express set up issue. The 0x80004005 error could also be an access denied error from the file system - it does not look like you are specifying a path to where the database files are being located. When SQL server does something it actually executes using the SQL Service account - so the creation of the underlying database files are performed as that account not the installing account - I have seen this cause some interesting file permission issues. Have you tried the InstallShield setup on different machines? You could try running the SQL Profiler to trace what is happening in SQL Express during the install. You could also try using SQLCMD to do a Create Database on the problem machine, just to see what happens. You are right about the User attribute, it lets WIX use an SQL User rather than a Windows Account, as far as I know you can't disable Windows Integrated Auth in SQL 2005, so for that reason I don't use the User attribute. What role does the user doing the install have in the SQL Express system. By default the Administrators group should be an SQL Admin - but you may need to double check this. Hope this helps Michael ________________________________________ From: John Stevenson-Hoare [john.stevenson-ho...@ffei.co.uk] Sent: Friday, 24 July 2009 8:04 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Help: 'Error 26201.Error -2147467259: failed to create SQL database' 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 ------------------------------------------------------------------------------ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
