SharePoint - MOSS 2007 Licensing w/ SQL Reporting Services

Asked By Kai Stankey

16-Dec-09 01:29 PM

After review the installation guide it appears that I will have to install
the MOSS 2007 WFE on our SQL Server to use the SSRS Sharepoint integration.
So to use the SSRS SharePoint integration do I need to have an additional
server license of MOSS so I can install the WFE on our SQL Server?

Thanks,

16-Dec-09 03:05 PM

You do not need to install SharePoint on SQL. You do need to install the SSRS
component on your SharePoint however.

--
Daniel A. Galant

Imagine what we could be... if we could just imagine.

16-Dec-09 04:31 PM

I understand that I can simply install the SSRS addin on our main SharePoint
WFE to display reports but per the instructions from the SQL 2008 server
documentation to run in SharePoint integration mode it appears that it
requires installing WFE on the SQL server.

From SQL Documentation - "If you are configuring a report server to run in
SharePoint integrated mode in a SharePoint farm that consists of multiple
servers, you must install the Web Front End application of a SharePoint
product or technology on the report server computer so that you can join the
report server computer to the farm. "

We only have one SQL License so SSRS is only installed on our SQL server.
So based on the above statement would it require an additional SharePoint
Server license.  If it does then we will simply only use the SSRS addin
instead of setting up SSRS to run in SharePoint integrated mode.

Thanks for your help.

Kai Stankey

17-Dec-09 10:02 AM

Correct, that is the Report server, meaning the server running the SSRS
component, not SQL.

--
Daniel A. Galant

Imagine what we could be... if we could just imagine.