Is the headline longer than the body? Not now I’ve included the fix for this situation as well as the initial rant. Maybe next time.
Yes, you may have an availability group – well done – and you may have installed SSRS on both servers. But you’ve only set up the reporting application to point to one of those? And you’ve given the link
https://<<Listener_Name>>/reports out to the users? Head/desk. I told you at the time that SSRS doesn’t play nicely with AGs. [Nearly misposted as SSRS doesn’t play nicely with SSRS, which, while valid, isn’t the point here…]
Here’s what you need to do to fix this / make sure it doesn’t happen:
- Install the reports on the active server
- Install the reports on the now-active server
- On each server, change the report data source to use the listener as the source, not
- On each server, set up the security group(s) and permissions your users require
[Disclaimer – this worked for this situation. It might not work for yours. Support here is worth what you paid for it. Don’t Drink and DBA.]
Only then will you be able to get away with distributing the AG Listener as the SSRS URL. I said this much at the time… Yes, I know things were a bit…difficult back then, but still. Oh well.
Where’s my LART? Or my coffee? Either will do