We have the following situation:
- RStudio Workbench 1.4.1717-3, "Juliet Rose"
- Professional Driver 1.8.0 (184.108.40.2060)
- MS SQL Server 2016 Always On Cluster
Server 1: Primary node
Server 2: Secondary node readonly
Server 3: Listener
Odbcinst.ini on RStudio Server
Driver = /opt/rstudio-drivers-1.8.0/sqlserver/bin/lib/libsqlserverodbc_sb64.so
RStudio_Version = 1.8.0
Version = 220.127.116.110
Installer = RStudio Pro Drivers
Driver = SQLServer
Server = Listener
Application_Intent = ReadOnly
Database = Rstudio_readonly_test
Port = 1433
UID = xxxxx
PWD = xxxxx
We have several sql databases that we can access with professional driver, no problem at all .
But now, we want connect directly to the readonly node by using the parameter “application_intent = readonly”, unfortunately that does not work.
Connect to the Listener/primary node (without application_intent): OK
Connect directly to the primary node: OK
Connect directly to the secondary node: OK
Primary and secondary DB can change the Server, that's why we need the parameter “application_intent”
Do you have any advice on how to solve this problem?
Thanks very much