SQL Server 2012 Read Only Connection

Question

How can I setup a read only connection to sql server 2012 without the need to create a read only user?

Answer 1

Connection String property ApplicationIntent

From the docs:

Declares the application workload type when connecting to a server. Possible values are ReadOnly and ReadWrite. For example:

ApplicationIntent=ReadOnly