[WiX-users] SQL Server Authentication vs. Windows

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Has anyone figured out this problem?  If you pass a property to the
SqlDB tag in a sqlscript element (i.e. SqlDb=3D"[SQLDBID]") the msi
compiles correctly, but the install fails with the error below.  My
goal is to allow the user to choose between windows authentication and
using sql server authentication (passing a username and password).=20
Rather than include my sqlscripts twice - inside each sqldatabase
element, I'd rather just have them reference a property that refers to
the correct database element.

Thanks,
Dana Gutride
dgu...@gm...

I tried to create to SqlDatabase elements. One with a user tag and one
 without:

 <SqlDatabase Id=3D"SqlDb" Database=3D"[SQLDATABASE]" Server=3D"[SQLSERVER]=
"
 User=3D"SQLUser"/>

 <SqlDatabase Id=3D"SqlDbWindowsAuth" Database=3D"[SQLDATABASE]"
 Server=3D"[SQLSERVER]"/>

 And it works fine if I chance the SqlScript element's SqlDb attribute
 manually between the 2. But I get a wierd failure when I try to put a
 proprety in the SqlDb like this:
 <SqlScript Id=3D"Procedures" BinaryKey=3D"DSH_Procedures" ExecuteOnInstall=
=3D"yes"
 ExecuteOnReInstall=3D"yes" ContinueOnError=3D"no" Sequence=3D"3"
 SqlDb=3D"[SQLDBID]"/>

 The installation just dissappears after the Configuring SQL Server step.
 Here is the verbose log for that section:

 Action 14:17:42: ConfigureSql. Configuring SQL Server
 Action start 14:17:42: ConfigureSql.
 MSI (s) (48:D8) [14:17:42:953]: Invoking remote custom action. DLL:
 C:\WINDOWS\Installer\MSI252.tmp, Entrypoint: ConfigureSql
 MSI (s) (48:60) [14:17:42:953]: Generating random cookie.
 MSI (s) (48:60) [14:17:42:968]: Created Custom Action Server with PID 1664
 (0x680).
 MSI (s) (48:10) [14:17:43:000]: Running as a service.
 MSI (s) (48:10) [14:17:43:015]: Hello, I'm your 32bit Impersonated custom
 action server.
 ConfigureSql:  Error 0x80070490: failed to find data for Database: SqlDb
 ConfigureSql:  Error 0x80070490: failed to execute install SQL strings,
 length may be too long, try add GO to break up
 Action ended 14:17:44: ConfigureSql. Return value 3.

   _____