Hi,
In the Production server having the enterprise sso service on the clustered SQL server, is this kind of architecture recommended. My assumption is configure new SSO in one of the SQL server(SQL1) and Join the existing group in the remaining servers(SQL2,SQL3,SQL4), if the the SQL1 goes down will the SSO transactions will continue to work without any SSO errors.
Kindly validate the design.