Messages fill the FglAM log an Azure SQL agent's AAD_PASSWORD (Active Directory Password) authentication method is deprecated.
Microsoft has deprecated the Active Directory Password (AAD_PASSWORD) authentication method for Azure SQL Database. Continuing to use it results in warnings and may break in future releases.
In the agent configuration, set the authentication mode to "Microsoft Entra Default" or "Active_Directory_Default" (maps to AAD_DEFAULT).
AAD_DEFAULT uses Azure's DefaultAzureCredential chain, supporting Managed Identity, Service Principal, and other secure methods automatically.
NOTE: AAD_DEFAULT doesn't specifically select one of AAD_INTERACTIVE, AAD_INTEGRATED, AAD_MANAGED_IDENTITY, or AAD_SERVICE_PRINCIPAL. Instead, it tries all supported methods in order (Managed Identity, Service Principal, Visual Studio, Azure CLI, etc.) based on environment and configuration. It is the most flexible and future-proof option.
