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 […]