New answers tagged


The issue here is that your Login on each node has a different SID on it. When you run ALTER USER it changes the DB user's SID to match the login on that particular node but after a failover the DB User SID no longer matches the SQL Login SID. The fix is to drop the SQL Login on one node and recreate it using the same SID as the other node. This will ensure ...

Top 50 recent answers are included