Testing direction of report queries to a read-only node of a high availability cluster. This is supposed to be done by specifying "ApplicationIntent=ReadOnly" in the connection string to that database server - but I cannot find where to specify in my Edit Connection settings - and the Role section's "Read Only" option is disabled saying "Driver does not support read only."

How can I switch SQL Server drivers, specify the connection string option, etc?

Thanks