I'm trying to connect to the secondary of an Availability Group in SQL Server. Usually you just do this by specifying 'ApplicationIntent=ReadOnly' in the connection string but it doesn't appear RStudio Professional Database Drivers allows this. Have done searches but come up empty. Is this doable or do I need to go back to the dreaded RODBC?
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.