SSMS – Application Intent ReadOnly

If you have an always on MSSQL availability group you can add
applicationintent=readonly;

to your connection string to connect as a read only user on the secondary mirror of your availability group. If you want to connect using Microsoft Sql Server Management Studio (SSMS) using the same intent, open a new window, hit connect, type in your secondary DB instance.

SSMS_CONNECT

Click “Options” and then “Additional Connection Parameters” and viola! You can now run read only queries without taxing your production SQL Sever instance!

SSMS_applicationintent_readonly