We are running a two node clustered database with HA enabled.
I'm wondering if someone has figured out a way to preserve the users when a HA failover occurs. Right now, the process is to run the secure check job and drop and re-create the users in security. This will allow the secondary to become the primary and resume Tessitura operations.
I think the UID assigned to the users changes when dropping and re-creating. Thus, even though user names and credentials are duplicates between the two nodes, the UID's are different. Has anyone overcome this with a job copy or something similar?
--
Regards,
Troy Nelson