September 5, 2017 at 8:54 am
Hi There,
I've never installed SSRS.
I have a 3 node cluster with 6 x 2008 r2 sql instances. The users of 1 of these instances wish to use reporting services.
I started to read up on installing SSRS on a cluster and it looks really hacky. In the absence of a test system, I'm nervous to try and follow this on my live system.
https://www.mssqltips.com/sqlservertip/2778/how-to-add-reporting-services-to-an-existing-sql-server-clustered-instance/
What would you do? Is there a better configuration? Installing on a standalone server? Just installing on a single node & accepting possible downtime? Or should I go for the install that tries to make the service cluster aware?
Appreciate any advice.
J.
September 5, 2017 at 9:02 am
As many answers are in the SQL Server realm...it depends. While the article you reference is a good example of how you can deploy SSRS in an existing clustered environment, you can install SSRS on a standalone SQL Server instance, and not have to worry about "hacking" it to make it cluster aware--which, by the way, does not work well--I've done this a few times, and sometimes the cluster recognizes it and swings it over with the other components, sometimes it doesn't, and sometimes it moves it over, but does not (or cannot) start the service.
However, if you need to have HA with SSRS, this is a viable solution. If uptime for SSRS is not a big priority, and you have other SQL Server instances where you can install it, I personally would put it on a stand-alone instance. NOTE: If you install SSRS on a server that does not already have the database engine installed, i.e SSRS by itself, it requires a license as if the database engine were installed.
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 5, 2017 at 9:30 am
Thanks Alan,
Good to hear of your experience. You're right, HA isn't a concern here and it's a relief not to be hacking around on live. I'll install on a standalone.
Forgive my complete ignorance, but am I right in saying I need 1 SSRS service per SQL instance? Or could I run reports for 2 instances against a single SSRS?
I don't need this atm, just looking forward.
Thanks
J.
September 5, 2017 at 10:10 am
No, as far as I know, you can have one installation of SSRS and produce reports for all instances of SQL Server in your environment. The "price tag" of that could be processing power--especially over the network. But, there is no limitation or expectation of installing SSRS on X number of SQL Server instances. So, you could very easily install SSRS on your standalone instance and use it to store and render reports for your cluster(s) and any standalone instances.
Hope that helps...
Alan H
MCSE - Data Management and Analytics
Senior SQL Server DBA
Best way to ask a question: http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 6, 2017 at 12:17 pm
Understood. Thanks Alan, you have really helped me. Cheers!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply