We have a SQL job that we run to copy all logins from the Primary node to all (3) Secondary nodes. For this one particular cluster, we can copy the logins to 2 of the secondary nodes, but not to one of them.
I tried adding a new user to Primary and when I ran the job on each secondary node, it gets copied to two of them, but not to one.
What could be the issue with this one particular server that would prevent me from copying a login?
I did check the SID and it is not in use on this server.
Also, the job runs with no errors, it just doesn't copy the login.
Thanks,