Re: [WiX-users] SqlDatabase trusted connection

2009-06-12 Thread Rob Mensching
..@joyofsetup.com] > Sent: 12 June 2009 04:18 > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] SqlDatabase trusted connection > > Neil Sleightholm wrote: > >> Thanks everyone for your help on this. I think I will go back to >> exec

Re: [WiX-users] SqlDatabase trusted connection

2009-06-11 Thread Neil Sleightholm
. Subject: Re: [WiX-users] SqlDatabase trusted connection Neil Sleightholm wrote: > Thanks everyone for your help on this. I think I will go back to > exec'ing sqlcmd and raise a feature request to allow connection without > elevated permissions. > The custom actions don't

Re: [WiX-users] SqlDatabase trusted connection

2009-06-11 Thread Bob Arnson
Neil Sleightholm wrote: > Thanks everyone for your help on this. I think I will go back to > exec'ing sqlcmd and raise a feature request to allow connection without > elevated permissions. > The custom actions don't run elevated; they're deferred but impersonate the user, including the user's

Re: [WiX-users] SqlDatabase trusted connection

2009-06-10 Thread Neil Sleightholm
n for Windows Installer XML toolset. Subject: Re: [WiX-users] SqlDatabase trusted connection 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 n

Re: [WiX-users] SqlDatabase trusted connection

2009-06-09 Thread Michael Osmond
: 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: I don't think this is an uncommon sc

Re: [WiX-users] SqlDatabase trusted connection

2009-06-09 Thread Neil Sleightholm
ows 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 localsyst

Re: [WiX-users] SqlDatabase trusted connection

2009-06-09 Thread Bob Arnson
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

Re: [WiX-users] SqlDatabase trusted connection

2009-06-09 Thread Michael Osmond
Niel, Two things to consider. 1. My experience is that in the trusted case the connection to SQL is as the user running the MSI. 2. There is also an issue of what you are actually doing in the SQL string/script - if it is doing anything outside of SQL (say a backup) then when it interacts wi