We have an SQL server hosted on Azure with multiple databases on it. It has a Server Admin set up (not using AD) with a password.
After X months (I'm guessing every 3rd?) that password gets locked(?) and our application gets an error that the Login Failed for that Server Admin. We are guessing there is some default password policy set on the SQL server since we can simply do a password reset via overview page and it works again.
Now the questions are, is there a password policy set by default? Can we disable/change this policy? And if yes, how do we do it?
Reference: https://docs.microsoft.com/en-us/azure/mysql/howto-create-manage-server-portal
Thank you.
