Written by 
We are trying to use SQL Server trigger for scaling application and trying to authenticate the SQL DB using Azure Service Principle. But no luck. We are keeping connection string in Kubernetes Secret and trying to use this. but no luck. Getting login failed error like ERROR mssql_scaler Found error pinging mssql: mssql: login error: […]
enter image description here enter image description here enter image description here I don’t know how to solve this "The client ‘live.com#naveenashwin59@gmail.com’ with object id ‘f8e06650-838b-4313-bcd2-2672fd66ff56’ does not have authorization to perform action ‘Microsoft.Authorization/classicadministrators/read’ over scope ‘/subscriptions/17543f2a-ac21-45ec-98a9-bd9dc218a1a1’ or the scope is invalid. If access was recently granted, please refresh your credentials" Source link