Neil,
I am not aware of anyway to use trusted as you indicate (not built in to the
WIX CA anyway). In the end you have to have a valid windows user context to
use trusted from, so you would still need a password (or security context) to
do a runas/switch user type of operation to run as a different user.
Bob indicated that the CA was running in impersonate, you maybe able to change
that somehow so it runs as system (I have never tried this.)
Michael
________________________________________
From: Neil Sleightholm [n...@x2systems.com]
Sent: Wednesday, 10 June 2009 4:07 PM
To: General discussion for Windows Installer XML toolset.
Subject: Re: [WiX-users] SqlDatabase trusted connection
That would explain what I am seeing. Is there any way to use a trusted
connection for local system? I tried this but it doesn't work:
<util:User Id="localsystem" Name="localsystem" />
<sql:SqlDatabase Id="MyDatabase" Server="." Instance="Inst1"
Database="master" User="localsystem" />
I don't think this is an uncommon scenario, we setup SQL so that the
application users don't have access to our database but some local NT
accounts do. I don't really want to use a SQL user as I can't see any
way of securing the password, you can always open the MSI and see it.
Thanks
Neil
-----Original Message-----
From: Bob Arnson [mailto:b...@joyofsetup.com]
Sent: 10 June 2009 03:39
To: General discussion for Windows Installer XML toolset.
Subject: Re: [WiX-users] SqlDatabase trusted connection
Neil Sleightholm wrote:
> When running SqlDatabase and SqlString as a trusted connection (i.e.
NT
> auth not Sql) can anyone tell be what account it runs as? I would
> expected it to be localsystem but it doesn't seem to be as my
> authentication keeps failing (if I use a SQL account it works so I
think
> this is the problem).
>
The SQL CAs are impersonated, so they run as the installing user.
--
sig://boB
http://joyofsetup.com/
------------------------------------------------------------------------
------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
