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?

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