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
