The login failure seems like connected to an IAM privilege in the subscription.
In Azure portal, connect the subscription blade. Go to Access Control (IAM) as shown and add a Role assignment for the service principle in the subscription. This should fix the issue as I think
----------
If the Answer is helpful, please click "Accept Answer" and upvote it