March 17, 2010 at 1:43 pm
We currently run a SQL Server 2005 Enterprise Cluster running on Windows Server 2003 R2. However, we're making the move to SQL Server 2008 running on Windows Server 2008 R2 running as an active/passive cluster. Currently I have my reporting services installed on another server but with the new hardware I have more than enough performance to run it all together. However we're finding a lot of conflicting information on clustering SSRS 2008. Some are saying that SSRS is not "cluster aware".
We're clustering just to give us some HA capability to fall back on in the event of a hardware failure.
So what's the story. Can we cluster SSRS 2008? How do people scale out SSRS 2008?
March 17, 2010 at 4:31 pm
SSRS is not cluster aware, however you can install the reporting services databases on a failover cluster.
you can create a 'scaled out' deployment but you need enterprise edition of SSRS.
some light reading:
http://msdn.microsoft.com/en-us/library/bb522745.aspx
http://technet.microsoft.com/en-us/library/ms157293.aspx
---------------------------------------------------------------------
March 17, 2010 at 4:40 pm
In addition to that reading, look up SSRS NLB (network load balance). You can install ssrs on a cluster box but would need to make SSRS a member of an NLB cluster.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 18, 2010 at 4:38 pm
Thanks guys, we will deploy to an NLB cluster dedicated to SSRS. Appreciate your responses.
March 18, 2010 at 4:51 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 18, 2010 at 9:13 pm
Hold on - you don't need an NLB cluster for this. Enterprise Edition allows for scale-out reporting services installation.
What you do is install reporting services on each node in the cluster, add the nodes in the scale-out options and now you can access from either node.
Additionally, since it is being hosted on both nodes - you'll have access through the cluster VIP, the SQL Server VIP or each individual node as needed.
No need to worry about clustering it at all, the only thing you would have clustered is the database.
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
April 22, 2010 at 9:36 am
That was my intended solution...install reporting services on each node in the cluster, add the nodes in the scale-out options and then access from either node. However whenever I try to install RS on the second node I get an error at the Installation Rules;
Existing clustered or clustered-prepared instance' failed.
The Instance selected for installation is already installed and clustered on computer xxxxxxx03.
To continue select a different instance to cluster
This happens when I use the New SQL Server stand-alone installation or add feature to existing installation wizard
Any suggestions? What am I doing wrong?
Thanks.
Bilex
April 22, 2010 at 7:44 pm
It sounds like you are trying to install the database engine again. Only select to install the reporting services component and any other non-cluster aware components you want on that node (e.g. SSIS and/or client tools).
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
April 23, 2010 at 11:35 am
Well, I do not get the option to uncheck the Database Engine Services. See screen shots
April 23, 2010 at 12:49 pm
Perform a new installation instead of modifying an existing one. Then, only select the Reporting Services component.
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
April 26, 2010 at 5:10 am
That worked by creating a named instance for SSRS. I guess that correct right?
April 27, 2010 at 9:52 am
New problem, when I navigate to the URL it's prompting for a user name and password. Any ideas or pointers. I have not found anything out there that has helped so far.
April 27, 2010 at 7:35 pm
bilex7226 (4/26/2010)
That worked by creating a named instance for SSRS. I guess that correct right?
You should not have had to do that - but it shouldn't be a problem.
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
April 27, 2010 at 7:36 pm
bilex7226 (4/27/2010)
New problem, when I navigate to the URL it's prompting for a user name and password. Any ideas or pointers. I have not found anything out there that has helped so far.
What changes did you make to IIS and/or the web site?
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
May 4, 2010 at 5:33 am
Jeff,
thanks for the followup. Don't have IIS installed..SQL2008 does not require IIS, except I am missing something. I did not change anything with the webservices. It does not prompt for authentication on the first node, but does so on the second node...weird eh?
Bilex
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply