topic Connection to Azure SQL DB ReadOnly Replica in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Connection-to-Azure-SQL-DB-ReadOnly-Replica/m-p/1821384#M9304 <P>Hallo Qlik Users,</P><P><SPAN>we are trying to connect our dashboards to the Azure SQL DB ReadOnly Replica.</SPAN><BR /><SPAN>We set the advanced parameters (s. attached files) and successfully loaded the data.</SPAN><BR /><SPAN>But after checking the logged connection on database we found out that Qlik used the ReadWrite version.</SPAN><BR /><BR /><SPAN>What is the correct why to make sure that Qlik connects with the Replica?</SPAN><BR /><BR /><SPAN>Thank you very much for your help!</SPAN></P><P><SPAN>Qlik Edition in use:<BR />Qlik Sense Enterprise SaaS<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qlik.png" style="width: 955px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/58417i11EA27FE0EE03C9B/image-size/large?v=v2&amp;px=999" role="button" title="Qlik.png" alt="Qlik.png" /></span></SPAN></P><P><SPAN>Kind regards</SPAN></P><P><SPAN>Margot</SPAN></P><P>&nbsp;</P> Fri, 10 Dec 2021 21:09:00 GMT MargotYu 2021-12-10T21:09:00Z Connection to Azure SQL DB ReadOnly Replica https://community.qlik.com/t5/Connectivity-Data-Prep/Connection-to-Azure-SQL-DB-ReadOnly-Replica/m-p/1821384#M9304 <P>Hallo Qlik Users,</P><P><SPAN>we are trying to connect our dashboards to the Azure SQL DB ReadOnly Replica.</SPAN><BR /><SPAN>We set the advanced parameters (s. attached files) and successfully loaded the data.</SPAN><BR /><SPAN>But after checking the logged connection on database we found out that Qlik used the ReadWrite version.</SPAN><BR /><BR /><SPAN>What is the correct why to make sure that Qlik connects with the Replica?</SPAN><BR /><BR /><SPAN>Thank you very much for your help!</SPAN></P><P><SPAN>Qlik Edition in use:<BR />Qlik Sense Enterprise SaaS<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Qlik.png" style="width: 955px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/58417i11EA27FE0EE03C9B/image-size/large?v=v2&amp;px=999" role="button" title="Qlik.png" alt="Qlik.png" /></span></SPAN></P><P><SPAN>Kind regards</SPAN></P><P><SPAN>Margot</SPAN></P><P>&nbsp;</P> Fri, 10 Dec 2021 21:09:00 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Connection-to-Azure-SQL-DB-ReadOnly-Replica/m-p/1821384#M9304 MargotYu 2021-12-10T21:09:00Z