applicationintent=readonly in Azure Data Studio

Recently, I had to use Azure Data Studio to access a application intent read only secondary replica. I had to use Azure Data Studio because I was using a Mac. I usually use SSMS on my Windows machines. If you want to connect with the “applicationintent=readonly” property via SQL Server Management Studio, you do so by typing it out in the “Additional Connection Parameters” as shown in the screenshot below:

Since I am fairly new to Azure Data Studio I was fumbling my way around to find the equivalent setting. And I finally found it…

applicationintent=readonly in Azure Data Studio

First, click on the connection, then click on Advanced

The first drop down option is for “Application intent.” This will show two options; Read Write, and ReadOnly. Choose ReadOnly.

The second drop down is for “Asynchronous processing.” This is a true/false option. Choose True. See screenshot below.

Done! Now you can connect to your secondary replica with applicationintent=readonly setting.

2 Replies to “applicationintent=readonly in Azure Data Studio”

  1. Thanks for the post. Question, though: is asynchronous needed to get applicationintent to work? And what does the async actually do? Found a few other posts and I’m none the wiser.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.