To test read intent connections to an AG Listener, I prefer to use SQLCMD but you can also test easily using SSMS. SQLCMD The -Kreadonly switch is your key to success here but remember to also specify the database using -d. When not set (and with an initial catalog of master for my login), I … Continue reading Test read intent connections to an AG Listener