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.