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…