Connecting to Always On High Availability Group using SQL Server Management Studio (SSMS)
1. In SQL Server Management Studio, enter the High Availability Group Listener name.
Then click on the [Options >>] button.
2. On the “Connection Properties” tab, increase the "Connection time-out:"
Default setting is 15 seconds.
Microsoft recommends setting it to 21 seconds per subnet for availability groups.
This setting is available SSMS versions 2005 and up.
3. Click on the “Additional Connection Parameters” tab.
This tab is available on SSMS versions 2012 and up and this is parameter available in SQL Native Clients based on .NET framework 4 and up.
Add an entry for: