How to create a dependency between two or more Availability Groups

Hi all,   Problem description: I got a specific scenario where I have to failover two or more AlwaysOn Availability Groups in the same time.  To explain by another way, I have to create a dependency between 2 Availability Groups. If one of them failover, the second one has to move also on the same…

1

How configure correctly AlwaysOn readable secondary replica for applicationIntent

  Hi all,   I would like to share with you an issue that I got recently because  I didn’t set  up correctly AlwaysOn to enable readable database on the secondary replica.   Problem description: When I am trying to connect to my application with .Net or PowerShell, I got the following issue only when I…

1

Keyword not supported: 'applicationintent'

  Problem description: When you try to connect to  your SQL Server by using powershell, .Net, sqlcmd… you got this error message: System.ArgumentException: Keyword not supported: ‘applicationintent’.   at System.Data.SqlClient.SqlConnectionStringBuilder.set_Item(String keyword, Object value)   at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)   Cause: The message occurs when you include ApplicationIntent=ReadOnly (AlwaysOn Availability Groups properties) in your connection string. And  the server…

0