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:[email protected]]
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
[email protected]
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users
