topic Connect to secondary replica of SQL Server using applicationintent= readonly in Connectivity & Data Prep

Connect to secondary replica of SQL Server using applicationintent= readonly

jananireddy1 — Mon, 07 Dec 2020 19:58:07 GMT

Hello fellow Qliker's

I am making a connection to Microsoft SQL DB using the Qlik MIcrosoft SQL connector from data sources list.

How would I be able to mention in here applicationintent= readonly as I do not want to load data from the primay db, iI always want my queries to hit the secondary db

Thanks in advance

Janani

Re: Connect to secondary replica of SQL Server using applicationintent= readonly

jananireddy1 — Thu, 17 Dec 2020 16:55:59 GMT

Here are the two articles i have been referring too but no luck on fix yet

1. https://www.sqlservercentral.com/forums/topic/read-only-routing-on-qliksense-application

2. https://community.qlik.com/t5/QlikView-Scripting/How-to-connect-to-secondary-replica-of-SQL-Server-AlwaysOn/td-p/1032644