Getting a strange error when using SqlDatabase with a user in Wix 4.

[erikhermansson79]

Hi,

Can anyone tell me why I'm getting the following error when using SqlDatabase with a user in Wix 4?

WIX0204 ICE03: _Validation table: Data in KeyTAble column is incorrect; Table: Wix4SqlDatabase, Column: User_, Key(s): MainDatabase

My package has the following configuration:

<Property Id="SQLSERVER" Secure="yes"></Property>
<Property Id="SQLINSTANCE" Secure="yes"></Property>
<Property Id="SQLDATABASE" Secure="yes" Value="test"></Property>
<Property Id="SQLUSER" Secure="yes"></Property>
<Property Id="SQLPASSWORD" Secure="yes"></Property>

<util:User Id="Sql_User" Name="[SQLUSER]" Password="[SQLPASSWORD]" />

<Component Id="DatabaseComponent" Guid="{A6DFCBCF-5F81-4266-9897-7AF4F5537137}" Directory="INSTALLFOLDER">
    <sql:SqlDatabase Id="MainDatabase"
                       ConfirmOverwrite="yes"
                       CreateOnInstall="yes"
                       CreateOnReinstall="no"
                       Server="[SQLSERVER]"
                       Database="[SQLDATABASE]"
                       Instance="[SQLINSTANCE]"
                       User="Sql_User" />
</Component>

If I remove the "User"-attribute from SqlDatabase I get no error, and I can see in the MSI, using Orca, that the user "Sql_User" is created in the "Wix4User"-table.

I get this error in both preview1 and rc1.

[barnson]

It's a bug: #7110