https://community.qlik.com/t5/Talend-Studio/Connect-to-ReadOnly-MS-SQL-Server-Database-through-tdbinput/m-p/2499262#M141664 <P>Hello,</P> <P><BR />I don't know if it will work but try connecting with a tDBconnexion/tDBInput component in JDBC</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dave_Simo_0-1735040017205.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/176038i1CA991C5994427C1/image-size/medium?v=v2&amp;px=400" role="button" title="Dave_Simo_0-1735040017205.png" alt="Dave_Simo_0-1735040017205.png" /></span></P> <P>Best Reagrds,</P> Tue, 24 Dec 2024 11:37:08 GMT Dave_Simo 2024-12-24T11:37:08Z https://community.qlik.com/t5/Talend-Studio/Connect-to-ReadOnly-MS-SQL-Server-Database-through-tdbinput/m-p/2499214#M141663 <P>I'm trying to connect to the ReadOnly instance of an MS-SQL Server database using tdbinput, and I've set the "Additional JDBC Parameters" in the advanced settings to "ApplicationIntent=ReadOnly". However, when I check the query output, it still shows that it's connecting to the READ_WRITE instance.</P> <P>I tested the same connection with "ApplicationIntent=ReadOnly" in SSMS, and it worked fine, showing that I was connected to the READ_ONLY instance.</P> <P>Has anyone encountered a similar issue or can suggest a solution for connecting to the ReadOnly instance using tdbinput?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="avinashu_0-1735019542714.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/176023i15935C372B156910/image-size/medium?v=v2&amp;px=400" role="button" title="avinashu_0-1735019542714.png" alt="avinashu_0-1735019542714.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="avinashu_1-1735019587177.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/176024iF2B641272A532EB5/image-size/medium?v=v2&amp;px=400" role="button" title="avinashu_1-1735019587177.png" alt="avinashu_1-1735019587177.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="avinashu_2-1735019736973.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/176025i2AB870CFF23151B6/image-size/medium?v=v2&amp;px=400" role="button" title="avinashu_2-1735019736973.png" alt="avinashu_2-1735019736973.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 24 Dec 2024 06:01:36 GMT https://community.qlik.com/t5/Talend-Studio/Connect-to-ReadOnly-MS-SQL-Server-Database-through-tdbinput/m-p/2499214#M141663 avinashu 2024-12-24T06:01:36Z https://community.qlik.com/t5/Talend-Studio/Connect-to-ReadOnly-MS-SQL-Server-Database-through-tdbinput/m-p/2499262#M141664 <P>Hello,</P> <P><BR />I don't know if it will work but try connecting with a tDBconnexion/tDBInput component in JDBC</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dave_Simo_0-1735040017205.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/176038i1CA991C5994427C1/image-size/medium?v=v2&amp;px=400" role="button" title="Dave_Simo_0-1735040017205.png" alt="Dave_Simo_0-1735040017205.png" /></span></P> <P>Best Reagrds,</P> Tue, 24 Dec 2024 11:37:08 GMT https://community.qlik.com/t5/Talend-Studio/Connect-to-ReadOnly-MS-SQL-Server-Database-through-tdbinput/m-p/2499262#M141664 Dave_Simo 2024-12-24T11:37:08Z