Can you please help me to configure a CMS for failover db( MS SQL 2014 ), where do I need to setup CMS db for failover DB. I tried to change under Database settings but it works only with manual switching under SDL Web Content Manager console.

Thanks in advance!!!

Anand