If "No impersonation" is set, it means the custom action function will be called in Local System context, of which token does not have Administrators group SID. I think there should be different elevation scheme with Impersonation bit set to get a token with Administrators group SID.
Chesong Lee On Dec 18, 2007 9:58 AM, Pankaj Bhatia <[EMAIL PROTECTED]> wrote: > Thanks Dimmick for your reply. > I am running latest V3 night build. I set NoImpersonate bit in the msi using > well known CustomAction_NoImpersonate script.. but things are same.. > > Here is my Wix code for DB > > <Component Id="ABCDB" Guid="$( var.ABCDbId)"> > <sql:SqlDatabase Id="AbcDatabase" Database="ABCDB" > Server="MyVISTA\SQLEXPRESS" > CreateOnInstall="yes" DropOnUninstall="yes" > ContinueOnError="no" > > <sql:SqlScript Id="CreateTables" ExecuteOnInstall="yes" > ExecuteOnUninstall="no" BinaryKey="CreateABCDbBin"/> > <sql:SqlScript Id="DropTables" ExecuteOnInstall="no" > ExecuteOnUninstall="yes" BinaryKey="DropABCDbBin"/> > </sql:SqlDatabase> > <CreateFolder/> > </Component> > > Could you figure out what's wrong!! > > Thanks in advance. > Pankaj Bhatia > > > > > On Dec 17, 2007 11:36 PM, Mike Dimmick <[EMAIL PROTECTED]> wrote: > > > > > > > > > > This sounds like a database server configuration issue. It sounds like the > custom action is running impersonated, which on Windows Vista with UAC > enabled, not running from an elevated command prompt, means that the token > used doesn't contain the Administrators group. A default installation of SQL > Server grants the 'sysadmin' server role only to the BUILTIN\Administrators > Windows security group server logon, and to the 'sa' SQL Server logon. > > > > > > > > I would have thought that any problems in this area would already have > been addressed. Which exact version of WiX are you using? > > > > > > > > -- > > > > Mike Dimmick > > > > > > > > ________________________________ > > > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] ] On Behalf Of Pankaj Bhatia > > Sent: 17 December 2007 18:45 > > To: wix-users@lists.sourceforge.net > > Subject: [WiX-users] Elevating msi on vista. > > > > > > > > > > > > > > Hi, > > I want to use UAC for my Wix generated MSI. I know the way for custom > actions. > > But I am looking for a similar solution for SqlDatabase extension. I can > succefully create the database if I run my MSI through elevated command > prompt but direct installation doesn't work. > > > > Any help would be appreciated. > > Cheers > > Pankaj > > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
