1

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 ...


Only top voted, non community-wiki answers of a minimum length are eligible