[wix-users] SQL database (sql:SqlDatabase)

[Joseph L. Casale]

-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf
Of Carlos Sosa via wix-users
Sent: Wednesday, September 13, 2017 4:30 PM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Cc: Carlos Sosa <carlos.sosa.us at outlook.com>
Subject: Re: [wix-users] SQL database (sql:SqlDatabase)

> The rest of the code, if I understand correctly, is going to try to create a
> database called 'Foobar' connecting using the credentials specified above
> Is the Server value not defined correctly? Should I use "LocalHost" or
> MachineName\MyInstance? I'm pretty sure I tried every combination I could
> think of with no luck.
>             <sql:SqlDatabase Id='SqlDatabase' Database='Foobar' User='SQLUser'
> Server=".\sqlexpress" Instance="MyInstance"
>               CreateOnInstall="yes" DropOnUninstall="yes"
> ContinueOnError="yes">
> And then run the script to create a table, etc.
>               <sql:SqlScript Id="CreateTable" BinaryKey="CreateTable"
> ExecuteOnInstall="yes" />
>             </sql:SqlDatabase>
> 
> Any help is appreciated.

A couple interesting searches bring a few links that might help:
https://stackoverflow.com/questions/14930196/error-2147467259-failed-to-create-sql-database-in-wix
https://stackoverflow.com/questions/39515481/error-0x80004005-when-i-tried-to-install-a-database-with-wix