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
