Questions about the installer

[Matthew7758]

https://docs.composable.ai/en/latest/Getting-Started/03-2.Deployment-Scripts/
When looking at this document, there are CADB_MGMT_INTEGRATED_USER and MEMBERSHIPSTORE_MGMT_INTEGRATED_USER.
Do these need to explicitly be set to FALSE when CADB_AUTH_TYPE and MEMBERSHIPSTORE_AUTH_TYPE are set to SQLSERVER? What is the priority/precedence for these flags?

[lhfiedler]

The default for CADB_MGMT_INTEGRATED_USER and MEMBERSHIPSTORE_MGMT_INTEGRATED_USER is TRUE. If these are TRUE, then the installer will use the windows credentials from the user that is currently running the installer to perform actions on the database (like creating the db if it's a new install, running the upgrades, setting up or updating the first admin user). The auth type is effectively WINDOWS and will use the installer's credentials for management activities. These options will not affect CADB_AUTH_TYPE or MEMBERSHIPSTORE_AUTH_TYPE.

CADB_AUTH_TYPE and MEMBERSHIPSTORE_AUTH_TYPE are used for determining how the Composable runtime will be configured to connect with the database. Options are WINDOWS, ADINTEGRATED, SQLSERVER, ADPASSWORD.

If CADB_MGMT_INTEGRATED_USER and MEMBERSHIPSTORE_MGMT_INTEGRATED_USER are FALSE then the installer will use the CADB_AUTH_TYPE and MEMBERSHIPSTORE_AUTH_TYPE for performing management related installation activities.

CADB_USERNAME, and CADB_PASSWORD are used if CADB_AUTH_TYPE is SQLSERVER or ADPASSWORD

MEMBERSHIPSTORE_USERNAME, and MEMBERSHIPSTORE_PASSWORD are used if MEMBERSHIPSTORE_AUTH_TYPE is SQLSERVER or ADPASSWORD