SSMS – Application Intent ReadOnly

If you have an always on MSSQL availability group you can add

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.


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