The primary and companion servers must have equivalent allow password downgrade values before you configure them for high availability. The allow password downgrade quorum attribute checks whether the value of allow password downgrade is the same on both primary, and secondary servers.
If allow password downgrade on the primary server is 1, and 0 on the secondary server, then the output of sp_companion is:
1> sp_companion "primary_server",configure 2> go
Step: Access verified from Server:'secondary_server' to Server:'primary_server'. Step: Access verified from Server:'primary_server' to Server:'secondary_server'. Msg 18836, Level 16, State 1: Server 'secondary_server', Procedure 'sp_companion', Line 392: Configuration operation 'configure' can not proceed due to Quorum Advisory Check failure. Please run 'do_advisory' command to find the incompatible attribute and fix it. Attribute Name Attrib Type Local Value Remote Value Advisory -------------- ----------- ----------- ------------ -------- allow password downg allow password 0 1 2 (1 row affected) (return status = 1)
A value of 2 in the Advisory column indicates that the user cannot proceed with the cluster operation unless the values on both companions match.
sp_companion do_advisory also lists the difference in the value of allow password downgrade on both servers.
Run sp_passwordpolicy ‘allow password downgrade’ independently on both the primary, and secondary servers to synchronize the value, and to ensure both servers are in the same state.
