asked
Reporting Services on Always-on Availability Group
We have a sqlserver always-on availability group setup with 2 nodes. (non-clustered, but mirrored from one another where one is primary and the other is backup) We now want to use SQL Reporting Services to allow the business to have a better reporting tool. So I assume that means installing SQLServer Reporting Services on both nodes. However we want them to have a single point of entry into the reporting services website. So the website part should move to another place (otherwise the user would need to have 2 links and try each of them to see which one works). We do not want to install another sqlserver standard edition on another machine (due to license costs) as it also would be pointless since we are not interested in the database part at the other machine, we just want the connection string to be set to the always-on availability group and let that one decide which node it has to fetch data from. What is the prefered way to do this? It can't be that difficult I think, but I find the documentation confusing.
The single point of entry can be the AG Listener name - it's just a network name and IP address so you can use it for anything. I have a remote desktop session open right now that is connected via the listener name to ensure that I'm connected to the "live" server. It should work the exact same way for a reporting services URL - just use the AG listener name in place of the computer name.
16 People are following this question.
