Azure: Login failed for user
The problem was two keys in generated connection string by Microsoft.. You must set to "Persist Security Info" and "TrustServerCertificate" keys value: "True".
In my case, net core 3.1, I was trying to connect supplying the connection string through Configuration.GetConnectionString
, that is stored in appsettings.json, the password had unicode values and the json file was saved in an encoding other than UTF-8. So, to solve the problem I had to save the json file in UTF-8 encoding and it worked.