sql server reporting services: We do not want to install IIS on our database server to run Reporting
Services. As I understand that if RS is installed on a seperate
server, an additional SQl Server license is required. This will be
pricey!

Are there any other options available? If we install IIS and RS on the
database server, how can we secure it from being exposed to the web?
Are there any better options or changes in the policy for SQL Server
Reporting Services 2005?

You understand the licensing issues and there have been no changes with RS
2005.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services


[quoted text, click to view]

Bruce,

Can you point me in the direction of the document that states this? Thanks.
-Tim

[quoted text, click to view]

Here is the best way to look at licensing. Reporting Services is part of SQL
Server. There is no separate licensing for Reporting Services. You will not
find any further description because all you need to do is look at SQL
Server licensing. This would be no different than installing Analysis
Services on a separate box. Or installing SQL Server DB on another box. The
best way to consider this is Office. Office is Word, Excel, etc etc. You pay
an Office license. That does not give you the right to install Word on one
PC and Excel on another and Access on a third. It gives you the right to
install any combination of the pieces of Office on one PC. It is no
different with SQL Server (the product). People think about SQL Server as
meaning the database product but if you go here:
http://www.microsoft.com/sql/prodinfo/overview/what-is-sql-server.mspx
you will see that MS definition of SQL Server is the complete
platform:Reporting Services, Analysis Services, Integration Services,
Notification Services, Replication Services, Relation Database. You cannot
install any of these without a license.
[quoted text, click to view]

SQL Server 2005 is a comprehensive database platform providing
enterprise-class data management with integrated business intelligence (BI)
tools. The SQL Server 2005 database engine provides more secure, reliable
storage for both relational and structured data, enabling you to build and
manage highly available, performant data applications that you and your
people can use to take your business to the next level.

The SQL Server 2005 data engine lies at the core of this enterprise data
management solution. Additionally, SQL Server 2005 combines the best in
analysis, reporting, integration, and notification. This enables your team
to build and deploy cost-effective BI solutions with which they can drive
data into every corner of your business through scorecards, dashboards, Web
services, and mobile devices.

[quoted text, click to view]


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services



[quoted text, click to view]