sql server reporting services: ssrs on a cluster -- sql server reporting services

You're in the

sql server reporting services

group:

ssrs on a cluster

jason
8/16/2006 11:23:02 AM

sql server reporting services: following up on a post from the setup forum.
that post concerned putting ss2000 and ss2005 on the same server, i found
out that was fine, which brings me to my next question.

would it be ill conceived to also run reporting services 2005 on this
cluster?

i would like to reuse the ss licensing and i don't expect much demand from
the
reporting services users. there will be some early adopters,
as time goes on it may expand, but that remains to be seen.

i don't really want to put new servers in place, and buy more licensing for
a handful of reports.

thanks

RE: ssrs on a cluster

weilu NO[at]SPAM online.microsoft.com
8/17/2006 3:59:46 AM

Hi Jason,

First, I would like to correct one thing. Reporting Services does not
support Failover cluster.

Although you could setup two Web-Front End Reporting Services site to work
as a Web Server Farm and connect to the same remote SQL Server as the
Report Server database, you could not Failover to another node in the
cluster.

As for the license issue, you will need two valid licenses of SQL Server
2005 Enterprise Edition for the computers running the Report Server, plus
another valid license of SQL Server 2005 for the computer running the
Report Server Database.

Hope this will be helpful!

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

RE: ssrs on a cluster

jason
8/17/2006 5:17:01 AM

Hello Wei,

thanks for you response.

Could i host just the database part of report server on a cluster, or are
you saying no part of SSRS is supported on a clustered envirnment?

on licensing, do i have the correct: if i put all of the SSRS components on
1 server, i'd just need that 1 license, but if i put the database on a server
and the iis piece on another i'd need 2 licenses.

thanks.

[quoted text, click to view]

RE: ssrs on a cluster

weilu NO[at]SPAM online.microsoft.com
8/18/2006 4:56:08 AM

Hello Jason,

You could put the Report Server database on the Cluster environment.

As for the license issue, yes, you need only one license if you put all the
component on the same server and if you put the reporting services and
report server database on the different server, you will need 2 license.

For more license issue, please refer the following url:

http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx

Hope this information will be helpful!

Sincerely yours,

Wei Lu
Microsoft Online Partner Support

=====================================================

PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix
issues and simple how to questions.

We also love to hear your product feedback!

Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

RE: ssrs on a cluster

weilu NO[at]SPAM online.microsoft.com
8/22/2006 12:00:00 AM

Hello Jason,

How is everything going? If anything update, please let me know.

Sincerely,

Wei Lu
Microsoft Online Community Support

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn