We have our Microsoft SQL server configured in VM IaaS. We are using service account to connect to server. As per password rotation policy, we have request to reset the password every three months. But , while resetting this password we are facing many issue like application downtime, manually replacing the password and it worst case we have to raise Change request and deploy the code in PROD environments.
Is there anyway we can avoid this issue in IaaS platform.