dbTalk Databases Forums  

Installing SSRS on an existing SQL Cluster

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering Installing SSRS on an existing SQL Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Installing SSRS on an existing SQL Cluster in the microsoft.public.sqlserver.clustering forum.



Reply
Page 8 of 8 < 1 2 3 4 5 6 7 8
 
Thread Tools Display Modes
  #71  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Installing SSRS on an existing SQL Cluster - 11-17-2008 , 03:52 PM





Same as scaling a web server farm. Users point to an application pool. The
back-end SQL Server handles statefulness, but the work is done at the RS
application layer.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"Robin9876" <robin9876 (AT) hotmail (DOT) com> wrote

How would you scale out SSRS for an application? As when specifying
the report server location you can only include one server.

On 14 Nov, 14:47, "Geoff N. Hiten" <SQLCrafts... (AT) gmail (DOT) com> wrote:
Quote:
The RS application is stateless. You can "farm" it across many application
servers for both scale-out and redundancy. State is maintained in two
back-end databases which you place on the clustered SQL host. Regardless
of
which front-end server each requist "hits" the user experience is exactly
the same. Think of SSRS as a web app, not as a database engine.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"brahma" <bra... (AT) discussions (DOT) microsoft.com> wrote in message

news:BB926E65-A15E-4482-9B8E-6214C221480C (AT) microsoft (DOT) com...

hi Geoff,

if node1 faild then node2 comes alive and i had installed reporting
services
on both nodes so what happen to reporting services.
RS also failover or what happend to RS if node1 failover to node2

Thanks,
Brahma

"Geoff N. Hiten" wrote:

You can install it to each node on a cluster, but there is no way to
make
SSRS "cluster-aware". It is like a web farm where more nodes add
scalability and redundancy.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Robin9876" <robin9... (AT) hotmail (DOT) com> wrote in message
news:b0f1f2c0-e9f0-481d-a58a-3d480c0f5df0 (AT) z28g2000prd (DOT) googlegroups.com...
Does that mean it can be configured on a cluster?

On Oct 24, 2:23 pm, "Geoff N. Hiten" <SQLCrafts... (AT) gmail (DOT) com> wrote:
SSRS is not natively cluster-aware. I usually don't install SSRS on
my
database clusters as it does not work and play well with other SQL
components on the same box. SQL 2008 got better, though.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Robin9876" <robin9... (AT) hotmail (DOT) com> wrote in message

news:54169668-78a5-4b71-b863-65927e4bafc8 (AT) m36g2000hse (DOT) googlegroups.com...

For an existing SQL 2005 cluster which is inactive/passive mode,
how
can you install SSRS as cluster enabled?
The only option seem to be a local instance for the SQL Server.


Reply With Quote
Reply
Page 8 of 8 < 1 2 3 4 5 6 7 8

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top