SQL Server ApplicationIntent=READONLY not working.

by Nov 4, 2014

Hi all,

I’m currently using ADS 14 to connect to a SQL Server 2012 cluster with read only routing enabled. The read only routing is working from sql server management studio. But when I set the parameter in ADS connection “ApplicationIntent=READONLY” it connects me to the primary and not the read only node. I was wondering if anyone else has got this working?



Jonathan Powers over 9 years ago

Aqua Data Studio uses the jTDS driver to connect to SQL Server and currently it does not
support the ApplicationIntent=READONLY property. We have logged an enhancement
request to support this option.

You can track the progress here.