SSRS16 on a Mirrored Server

Question

SSRS16 on a Mirrored Server

Giovanni Michielin

SSC Veteran

Points: 209
More actions
April 21, 2017 at 10:34 am

#329903

Dear all,
I would like to know if I can run SSRS16 on a mirrored MSSQL 2016 server.
I am going to upgrade from MSSQL 2005 to 2016 and would like to have 2 separate mssql instances in order not to affect performance while running SSRS reports.
Is this a good solution.
Thanks
Giovanni

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

You 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

Giovanni Michielin SSC Veteran Points: 209 More actions · Answer 2

Sue_H - Friday, April 21, 2017 4:07 PM
Thank you very much Sue,
I really appreciate your advice,
Giovanni
You 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

Giovanni Michielin SSC Veteran Points: 209 More actions · Answer 3

Sue_H - Friday, April 21, 2017 4:07 PM
Sue ,
In order to run SSRS reports with Always on configuration do I need MSSQL 2016 enterprise edition ? I do only have Standard Edition.
Thanks
Giovanni
You 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