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

[Carlos Sosa]

Thank you for the links, I have read those in my research before posting this question, I went a doubled checked but still couldn't find a solution.
At this point I'm switching gears to c# and a custom action....
Trying to use WIX functionality but it's just not working for me.

Thanks.

-----Original Message-----
From: Joseph L. Casale [mailto:jcasale at activenetwerx.com] 
Sent: Wednesday, September 13, 2017 5:13 PM
To: 'WiX Toolset Users Mailing List' <wix-users at lists.wixtoolset.org>
Cc: Carlos Sosa <carlos.sosa.us at outlook.com>
Subject: RE: SQL database (sql:SqlDatabase)

-----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