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?
Thanks
Response
Jonathan Powers over 9 years ago
Hello,
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.
http://www.aquaclusters.com/app/home/project/public/aquadatastudio/issue/10758