SQLTeam.com | Weblogs | Forums

Can't copy login to one server in a cluster

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.


What do you see in the job history messages?
Does your script tell you the number of logins that have been coped after it has been executed?