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 with the OS it is as the acount that the SQL Server service is running as (which may be network service, system or a named account). Michael PS: I have been using trusted in SQL for about 3 or 4 years with pretty much no issues. ________________________________________ From: Neil Sleightholm [n...@x2systems.com] Sent: Wednesday, 10 June 2009 7:44 AM To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] SqlDatabase trusted connection 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 code I am using is: <sql:SqlDatabase Id="MyDatabase" Server="." Instance="Inst1" Database="master" /> (this is just a reference in the Fragment) <Component ... > <sql:SqlString Id="sql1" ExecuteOnInstall="yes" Sequence="1" SqlDb="MyDatabase" SQL="...." /> </Component> Thanks Neil Neil Sleightholm X2 Systems Limited n...@x2systems.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
