February 3, 2010 at 8:08 am
Hello Guys
I am trying to install and configure Reporting Services in a SQL Cluster environment and I haven't been able to do so.
Any advice on how to install it and configure it.
Thanks in advanced for you help
February 3, 2010 at 10:40 am
Reporting Services is not cluster aware - and it is not recommended that you set it up that way. If you want it to be accessible from all nodes in a cluster, you need to install the Enterprise version and build a scale-out deployment.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 3, 2010 at 12:17 pm
I mostly agree with Jeff. Scale out with Enterprise is probably the best way. And SSRS is not cluster aware. You could probably build a number of report servers and put a load balancer in front that would likely handle what you are trying to do.
I am a strong proponent of seperating the Reporting services piece from the back-end piece. The main reason is that I don't EVER want them in contention for resources. You can point a reporting services server at a clustered SQL box by simply giving it the SQL Cluster name, let the cluster service keep track of where the actual server is running.
Better yet, what is your end goal?
CEWII
February 3, 2010 at 12:34 pm
Just note that if you decide to separate out the web portion from the database, you need to purchase additional license for the web portion. It is only free if you have them installed on the same system.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 3, 2010 at 12:37 pm
Agreed.
CEWII
February 3, 2010 at 12:40 pm
last year we did this
we had a SQL 2000 server with database services and RS on it. management wanted high availability. we took this server along with a SQL 2005 x64 server that was also used for BI and put them on a SQL 2005 x64 cluster. and bought two more servers for the web portion. works very well, but it took months to get everything transfered over. it took me a week of going through every report manually to verify permissions and that it ran in the new environment. i think it was close to 1000 reports
February 3, 2010 at 1:57 pm
We have an IIS base application that use SSRS as reporting engine. We were able to installed and patched SSRS, but when we try to create the reporting DB we were getting errors. We created the DB manually by creating the SQL Script from a working SSRS server and when we try to configure it fail and if you try to go to http://clustername/reports we are getting the SSRS is not running and it is.
February 3, 2010 at 2:44 pm
Because reporting services is not cluster aware that isn't likely to work.
CEWII
February 3, 2010 at 2:59 pm
To get it to work that way, you have to install Enterprise version and build a scale-out deployment. You cannot setup multiple web servers accessing and using a single reporting services database any other way.
Here is a document that will help - at least it shows a couple of different setup configurations and licensing information: http://www.microsoft.com/sqlserver/2005/en/us/Special-Considerations.aspx#passive
The only way to get something like that to work is to start with clustering IIS - which is no longer supported by Microsoft and is not recommended anyways.
If you install Enterprise Edition - you then install Reporting Services on each node and setup your scale-out deployment. Then, you can access reporting services using either node or the virtual IP addresses. But, again - if you do that you have to pay for licensing on each system hosting reporting services.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 3, 2010 at 2:59 pm
Thank you very much guys for help me with this issue. Now we know for sure what needs to be done. A different server running SSRS
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply