Azure SQL Admin Username & Password work from portal but not inside Github Workflow

Question

I'm deploying a serverless Azure SQL instance using these scripts:

1. Github workflow: master_hqdqhengdtz4w-website.yml that calls the bicep files
2. Bicep to deploy serverless Azure SQL: deploy-SqlSvr.bicep & associated parameter json: deploy-SqlSvr-parameters.json
3. Bicep to deploy web site: deploy-AADAccessAzureSQLBlazorSvr.bicep

I'm getting an error here indicating that the login failed using the serverAdmin in the workflow...

However, when I go to the portal using the serverAdmin account and the same password, it lets me in...

So why cannot I log in with the admin & password inside the github workflow? I have recently reset the password in the github secret (secrets.AZURE_AD_ADMIN_PASSWORD) so I know it has the correct password.

As you can see from the github git history, I tried to comment out the ActiveDirectory resource (as generated by the portal template) but this did not help (same error as before: 5126379370).

Thu Sep 29 2022 Afternoon Update 001

I just edited the master_hqdqhengdtz4w-website.yml (and pushed) to revert to an earlier strategy of fetching the SQL Svr Admin password from Github secret instead of the key vault so we know there is no possibility of having two disparate passwords. The same Github secret password is used to both configure the Azure SQL database and with sqlcmd (to execute queries) and it is giving me the same error!

Answer 1

Problem solved: I had a typo in my bicep file so that the server name in the bicep was inconsistent with the github workflow file. Thanks for the help!