Creating an upgrade with CA which uses SQL Login

[SamDman]

I have a Basic MSI install. I'm developong the upgrade which has a CA using the SQL Login info. I have ISSQLServerValidate in the sequence which loaded the login data for Repair and Remove, but does not load this info for an upgrade.

Am I missing something? Not sure how to get the Server and Login credentials loaded for the upgrade. I need the following data for the CA:
IS_SQLSERVER_SERVER
IS_SQLSERVER_AUTHENTICATION
IS_SQLSERVER_USERNAME
IS_SQLSERVER_PASSWORD

[Snoopstah]

Have you added a connection via the SQL Scripts view in the IDE and populated the values there?

[SamDman]

Yes, I have a connection.
Looking at the MSI Log, the connection defaults are loaded. It does not load the parameters configured in the original install.
I tried creating an empty script, hoping this would get the data to load. Didn't work.

[hidenori]

What type of upgrade are you using?

[SamDman]

It is setup as an automatic Upgrade Item. Is that what you needed to know?

[hidenori]

I need to know if it is a minor upgrade or major upgrade. If you are not sure, would it be possible for you to post a Windows Installer verbose log for the installation?

Thank you.

[SamDman]

it is a minor upgrade.

Attached is the log file.
For a major upgrade the values are loaded, but not in a minor.

[SamDman]

Figured it out.
Had to remove some of the Condition for ISSQLServerValidate - just use Installed now and it worked