question

Does the login have SELECT access to the view? Have you seen this? [ https://msdn.microsoft.com/en-us/library/hh213417.aspx#ReadOnlyAppIntent][1] The application intent connection string property expresses the client application’s request to be directed either to a read-write or read-only version of an availability group database. To use read-only routing, a client must use an application intent of read-only in the connection string when connecting to the availability group listener. Without the read-only application intent, connections to the availability group listener are directed to the database on the primary replica. The application intent attribute is stored in the client’s session during login and the instance of SQL Server will then process this intent and determine what to do according to the configuration of the availability group and the current read-write state of the target database in the secondary replica. [1]: https://msdn.microsoft.com/en-us/library/hh213417.aspx#ReadOnlyAppIntent

Yes, The user has rights to all objects. I have read this @msdn and understand ApplicationIntent and how it is set. However, as a DBA I do not manage the code for the connection string, our developers do. Therefore I am relying on what they are telling about setting the connection string properly. What I'm trying to do is validate that a live connection is truly using the ApplicationIntent configuration. Ideally, I would like capture the connection properties as it's in use to validate the config is being set properly