Authorization failover between primary/secondary

[abdulkareem-siddiq]

Implement authorization recovery (401) if possible by swapping with secondary connection string.