I hate decoding custom action types - what's the impersonation setting there? If the custom action is running with no impersonation it's running with the local system account, and that probably doesn't have the rights to create a database.
Is there a good reason to create the database at install time instead of just shipping it in your setup? Phil Wilson -----Original Message----- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: Wednesday, March 24, 2010 10:47 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Create MS SQL Server 2008 database during installation. Hi Error 0x80004005: failed to create to database: 80004005 - is Access Denied. Regards Michael -----Original Message----- From: Asiri Wanigarathne [mailto:waas...@gmail.com] Sent: Thursday, 25 March 2010 3:43 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Create MS SQL Server 2008 database during installation. Hi Bob, thanks for the reply. here are the few linnes from the log just before the error occured. I tried it on SQL server 2005 express installation. My target is SQL Server 2008. MSI (s) (40:80) [15:38:34:583]: File: C:\Program Files\WIX\WindowsFormsApplication1.exe; To be installed; Won't patch; No existing file MSI (s) (40:80) [15:38:34:583]: Source for file 'filF7ACBEF0DD4EC370428FC8B34F8A49E4' is compressed MSI (s) (40:80) [15:38:34:593]: SOFTWARE RESTRICTION POLICY: Verifying object --> 'C:\WINDOWS\Installer\333e3.msi' against software restriction policy MSI (s) (40:80) [15:38:34:593]: Note: 1: 2262 2: DigitalSignature 3: -2147287038 MSI (s) (40:80) [15:38:34:593]: SOFTWARE RESTRICTION POLICY: C:\WINDOWS\Installer\333e3.msi is not digitally signed MSI (s) (40:80) [15:38:34:593]: SOFTWARE RESTRICTION POLICY: C:\WINDOWS\Installer\333e3.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (40:80) [15:38:34:593]: Note: 1: 2318 2: C:\Program Files\WIX\WindowsFormsApplication1.exe MSI (s) (40:80) [15:38:34:593]: Executing op: CacheSizeFlush(,) MSI (s) (40:80) [15:38:34:593]: Executing op: InstallProtectedFiles(AllowUI=1) MSI (s) (40:80) [15:38:34:593]: Executing op: ActionStart(Name=CreateDatabase,Description=Creating Databases,) MSI (s) (40:80) [15:38:34:593]: Executing op: CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********) MSI (s) (40:78) [15:38:34:603]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI5.tmp, Entrypoint: CreateDatabase CreateDatabase: Error 0x80004005: failed to create to database: 'TestDatabase', error: unknown error MSI (c) (2C:30) [15:38:51:175]: Font created. Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg Error 26201. Error -2147467259: failed to create SQL database: TestDatabase, error detail: unknown error. MSI (s) (40!7C) [15:38:53:449]: Product: WIX -- Error 26201. Error -2147467259: failed to create SQL database: TestDatabase, error detail: unknown error. Action ended 15:38:53: InstallFinalize. Return value 3. also attached the full log file. thanks Regards, Asiri Wanigarathne On 25 March 2010 07:17, Bob Arnson <b...@joyofsetup.com> wrote: > On 3/22/2010 10:36 PM, Asiri Wanigarathne wrote: > > My installer fails with following error message: > > > > Error - 2147467259. Failed to create SQL database. > > > > TestDatabase, error detail: unknown error. > > > > There's additional logging before that line that might be helpful to > pinpoint the cause. > > -- > sig://boB > http://joyofsetup.com/ > > > > ---------------------------------------------------------------------- > -------- Download Intel® Parallel Studio Eval Try the new > software tools for yourself. Speed compiling, find bugs proactively, > and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users *** Confidentiality Notice: This e-mail, including any associated or attached files, is intended solely for the individual or entity to which it is addressed. This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify the sender immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person. This email comes from a division of the Invensys Group, owned by Invensys plc, which is a company registered in England and Wales with its registered office at Portland House, Bressenden Place, London, SW1E 5BF (Registered number 166023). For a list of European legal entities within the Invensys Group, please go to http://www.invensys.com/legal/default.asp?top_nav_id=77&nav_id=80&prev_id=77. You may contact Invensys plc on +44 (0)20 7821 3848 or e-mail inet.hqhelpd...@invensys.com. This e-mail and any attachments thereto may be subject to the terms of any agreements between Invensys (and/or its subsidiaries and affiliates) and the recipient (and/or its subsidiaries and affiliates). ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users