The custom actions used in the WixSQLExtension do not have the "no-impersonate" bit set, so they never run as LocalSystem (except in the rare instance that the installation were being performed by a service running as LocalSystem). Thus, if you are using the WiX-supplied SQL support you must launch the installation itself from an account with the desired access.
The only ways to run a custom action as LocalSystem are to run it deferred with the Impersonate attribute set to "no" in the CustomAction element in your authoring where the Execute attribute is set to some in-script type ("deferred", "rollback", or "commit"), which cannot be run from the UI since they must be between InstallInitialize and InstallFinalize in the InstallExecuteSequence table. -----Original Message----- From: Stelios Kyprou [mailto:stelios.kyp...@formicary.net] Sent: Wednesday, July 14, 2010 12:57 PM To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] Using Integrated security for connectionstring in CustomAction Hello all! Let's say that i am using a C# custom action, to validate the database connectionstring that a user has entered in a dialog. If the user has selected to use Integrated Security, and the account of the Windows Service that will be running the application is "Local System", that would mean that when the service is running, when connecting to the database it would use the "Local System" to try and access it(which is what i want). In my c# custom action, when i try and connect to the db using Integrated Security, would it use the "local system" account to connect(which i think is the account the installer is running as)? or will it use the account of the user that is logged in the machine(which will fail to connect)? In the latter case, any ideas on how to make it run as local system? Thanks in advance, Stelios -- Stelios Kyprou Systems Engineer Formicary - delivering quality financial technology solutions(TM) www.formicary.net ---------------------------------------------------------------------------- This message is confidential and may be privileged. It is intended solely for the named addressee. If you are not the intended recipient, please inform us. Any unauthorised dissemination, distribution or copying hereof is prohibited. Formicary Limited registered office in England and Wales, address 1 Taillar Road, Hedon, East Yorkshire HU12 8GU, registration number 3894343, VAT number 747644304, does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users