Hello WiX Community, I have the following problem.
I have a number of SqlString elements which run "CREATE DATABASE ... FOR ATTACH" kind of queries. It fails to run on SQL 2008 (I tested on R2, but it seems that pure 2008 is also affected), DEFAULT INSTANCE ONLY. I mean, if I specify any named instance (like .\SQ:EXPRESS) it works perfectly fine. This is the excerpt from the log file: ... MSI (s) (50:AC) [20:36:07:604]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings...,) Action 20:36:07: ExecuteSqlStrings. Executing SQL Strings... MSI (s) (50:AC) [20:36:07:604]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********) MSI (s) (50:80) [20:36:07:604]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI7A5C.tmp, Entrypoint: ExecuteSqlStrings ExecuteSqlStrings: Entering ExecuteSqlStrings in C:\Windows\Installer\MSI7A5C.tmp, version 3.6.2005.0 ExecuteSqlStrings: Error 0x80004005: failed to connect to database: 'master' Error 26203. Failed to connect to SQL database. (-2147467259 master ) MSI (s) (50!C4) [20:36:26:646]: Product: MyProduct 2.0 - trunkdefaultsql -- Error 26203. Failed to connect to SQL database. (-2147467259 master ) CustomAction ExecuteSqlStrings returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox) Action ended 20:36:26: InstallFinalize. Return value 3. ... I tested on both WiX 3.5 (release build) and WiX 3.6 (latest available, 2201). Has anyone seen this before? What could be the reason? I tried reporting this as an issue, but developers responded that it doesn't sound like a WiX issue... Thanks in advance, -- Yan ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
