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
- Update 4.0.2 for Microsoft .NET Framework 4 – Runtime Update
- An update introduces support for the AlwaysOn features from SQL Server 2012 to the .NET Framework 3.5 SP1
Michel Degremont | Xbox Live Music - DBA Team - SQL Server & PDW |