After upgrading to Adaptive Server 15.0.2 and successful configuring HA, on the first connection to the primary server, the password of the user login is updated on both the primary and companion servers. This synchronizes the login password on primary and companion with the same on-disk encryption format. This is done to avoid password reset or locking when the “allow password downgrade” period ends as described in sp_passwordpolicy and with password downgrade to earlier Adaptive Server 15.0 versions with sp_downgrade. By synchronizing the password encryption format, the login passwords can continue to be used without being reset or locked by sp_passwordpolicy or sp_downgrade.
After successfully setting up the HA environment, ending the “allow password downgrade” period must be done separately on the primary and companion servers. Similarly, if downgrade to a previous version of Adaptive Server 15.0 is needed, the sp_downgrade action must be executed separately on the primary and companion servers.
