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 does not recognize the property.
KB Extract number 2544514: “When the ApplicationIntent property is set to ReadOnly, the client requests a read access operation when it connects to an AlwaysOn-enabled database. The server will enforce the read-only access operation both at connection time, and during a USE database statement, but only to an AlwaysOn-enabled database. When the ApplicationIntent property is set to ReadWrite, the client requests a regular (read-write) access operation when it connects to an AlwaysOn-enabled database. The default setting for the ApplicationIntent property is ReadWrite.”
Resolution: You have to install the update that introduces support for the AlwaysOn features from SQL Server 2012
Michel Degremont | Xbox Live Music – DBA Team – SQL Server & PDW |