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

Carlos Sosa carlos.sosa.us at outlook.com
Wed Sep 13 14:19:15 PDT 2017


Hello, I'm trying to create a database using Wix but cant get it to work:

  <Component Id="SqlComponent" Guid="4DXXX56A-4F01-4E1C-A260-BF8BA4DXXXXD" KeyPath='yes'>
            <util:User Id="SQLUser" Name="TEST\Administrator" Password="MXXX1XXXX" CreateUser="no" />
            <sql:SqlDatabase Id='SqlDatabase' Database='Foobar' User='SQLUser' Server=".\sqlexpress" Instance="MyInstance"
              CreateOnInstall="yes" DropOnUninstall="yes" ContinueOnError="yes">
              <sql:SqlScript Id="CreateTable" BinaryKey="CreateTable" ExecuteOnInstall="yes" />
            </sql:SqlDatabase>
  </Component>

In the logs I get: CreateDatabase:  Error 0x80004005: failed to create SQL database but continuing,
But ican't figure out why, any ideas?

Best


More information about the wix-users mailing list