Home Forums Reporting Services SSRS 2016 SSRS16 on a Mirrored Server RE: SSRS16 on a Mirrored Server
April 23, 2017 at 11:01 pm
Sue_H - Friday, April 21, 2017 4:07 PMThank you very much Sue,
I really appreciate your advice,
GiovanniYou probably don't want to think about mirroring for that upgrade since it is going away - the replacement being always on availability groups.
In terms of staying with mirroring - no it won't work with SSRS. The biggest issue being that only user databases can be mirrored.
If your main concern is just with reporting interfering with other activities on a database server, you could install SSRS on it's own server. It doesn't need to be on the same server as other user databases. If it's used heavily, you'd probably want to use two servers - one for the databases and the other for the Services.
If availability is a concern, going to always on availability groups in 2016 would be better than mirroring. The requirements, issues, behaviors in this environment are documented in this Microsoft article:
Reporting Services with Always On Availability Groups (SQL Server)Sue