How do you configure a WCF-SQL adapter to get data from a SQL2012 "always on" replica database?


  • The connection has to be made to the SQL 2012 Availability Group Listener, and the connection has to be able to set the “ApplicationIntent” parameter. This tells the SQL Listener that the connection is a read-only intent connection, and that it should be redirected to a readable secondary replica. Without that working the connection will be made to the primary database which is not what I want ( ).

    How do you configure the “ApplicationIntent” parameter on a WCF-SQL adapter? I can't see any way to do it.

    Tuesday, December 17, 2013 8:01 PM

All replies