We have an AG setup that has a primary replica and a synchronized commit secondary replica that we use for reporting (SQL 2016, Windows 2016, SQLdm 10.2). Since we use it for reporting, we want to monitor both replicas rather than just the listener. The problem we're having is that the secondary replica has alerts that bounce between running and unable to monitor. In between, we hit a transition state of Severity:
SQL Server status: Truncated functionalities available as user is non-admin
Which is strange because the user is a sysadmin and the OS user is an admin on the machine. I'm wondering if it's attempting to access the DB's without setting the application intent to ReadOnly.
Has anyone else run into this? Otherwise, I might open a support ticket.