Passwords updated after upgrade

Upon the first connection to the primary server after upgrading and configuring for high availability, the user login password synchronizes on both the primary and companion servers with the same on-disk encryption format. This avoids password reset or locking when the allow password downgrade period ends, and passwords are downgraded to an earlier version of Adaptive Server. Login passwords continue to be used without being reset or locked by sp_passwordpolicy or sp_downgrade.

After successfully setting up high-availability environment, end the allow password downgrade period separately on the primary and companion servers. Similarly, downgrade to an earlier version of Adaptive Server, execute sp_downgrade separately on the primary and companion servers.