Apologies in delayed response on this.
Checking the SQL Server Always On AG on AKS it looks like this solution makes use of environment variables
SQL_SAPASSWORD for the SQL Server.
Now there is no way to change the environment variables in a container without restarting the container.
Also, from this document it seems like the environment variables are being populated from secrets that the CNAB package installation creates.
Hence, you can try to edit the sa password and/or master password secrets (kubectl edit) using the base64 encrypted values of the new password you want to set.
However, this will require restart of the pod (by deleting pods if controlled by a deployment/replicaset/statefulset/daemonset or in case of standalone pods by saving the output of
kubectl get po <podname> -o yaml> $filename , deleting the old pod and
kubectl apply -f $filename)
Maybe the image does not boot with systemd as init system hence systemctl does not help. You can try
Hope this helps.
Please 'Accept as answer' if the provided information is helpful, so that it can help others in the community looking for help on similar topics.