• When they were created about a month ago, I used sp_help_revlogin. I scripted out the users on the old server, created on the primary node, used sp_help_revlogin to get the creation script with the SID, created on the secondary node. This happened twice when the Availability Group failed over to the secondary node. The application could not login. I had to update the password on the SQL users.

    MCSE SQL Server 2012\2014\2016