A CSV import using the Azure SQL CLI (Command Line Installer) instfails with: "db credentials type must take one of the following values : SQL SERVER AUTHENTICATION or AZURE ACTIVE DIRECTORY (AD) AUTHENTICATION or SKIP" when using AAD_Password, AAD Password or other synonyms.
SQL PI agents are not added when using the Enable PI collection option in the CLI installer
Accepted canonical values are SQL_Server_Authentication, Azure_Active_Directory, and SKIP.
The CLI installer is not designed to pass SQL PI repository connection information (i.e. SQL Server Repository hostname, userid, password, database name, and Raw data folder) to to create the SQL PI Repository agent in the FMS. As noted in the README file "a PI repository must be already installed".
For Active Directory Authentication
In your input CSV set the DB Credentials Type column to Azure_Active_Directory for AAD authentication.
For SQL PI
Either
Enhancement Request FOG-14107 has been logged to correct and improve the contents of the installer README file. This will be reviewed by Product Management for inclusion in a future release of the SQL Server cartridge.
