How does WiX schedule it's custom actions? Normally CA's are scheduled for deffered no-impersonate but in the case of intermachine sql execution using SSPI this would result in the computer account (assuming there is a domain) trying to authenticate to the remote machine rather then the person doing the installation. InstallShield schedules the CA for impersonation for this reason. Either way, I frequently put a check in my installer that the sql server name contains (local) because I don't like the idea of building a database remotely with no entries in ARP and a dependency on the network.
Are you connecting using integrated auth (sspi) or are you using a SQL login (sa)? ---------------------------------------- From: "aman jha" <er.amanjha...@gmail.com> Sent: Wednesday, August 01, 2012 8:39 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Run scripts on remote sql server Hi All, I have created a installer which i suppose to run some sql scripts on SQL server which is located in network. When I am using Server installed on local machine then its working fine.but if I use remote server then it throws exception failed to connect to server. I also tried like I used my local credntial where its working fine and copied the installer to different machine,then also it is failing. Following is the code which I am using <util:User Id="SQLUser" Name="[USERNAME]" Password="[PASSWORD]"></util:User> <sql:SqlDatabase Database="msdb_fil" Id="SQLDb" Server="[SERVERNAME]" Instance="SQLEXPRESS" User="SQLUser"></sql:SqlDatabase> <Component Id="cmp" KeyPath="yes" Guid="*" Directory="dir"> <sql:SqlScript User="SQLUser" ExecuteOnInstall="yes" Id="Script1" SqlDb=" SQLDb" BinaryKey="SQLBinary"></sql:SqlScript> </Component> <Binary Id="SQLBinary" SourceFile="~\TempSQL\TempSQL.sql"></Binary> Thanks In advance ---------------------------------------------------------------------------- -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
