Reporting Services on a Single Server Installation

Question

1)Is it possible to install Repoting Services on a MOSS single server environment?
2)What are the steps?

I have a SQL 2005 SP2 server that I'm trying to integrate with the MOSS single server environment. I have added the MOSS 2007 web front in to the SQL 2005 SP2 and installed the Reporing services on MOSS server. I do not see a section that says Reporting Services in Central Administration. 

Need help..... 

Answer 1

Reporting Services questions go to Business Intelligence.

Moving this.

---

WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx

Answer 2

I think the easiest way (We use it always to start learning something) is always to install every thing in the same machine..But ofcourse for performance issues this is not good at all.

You should check the following requirements:
1-You have SQL 2005 standard edition at least+SP2.
2-Make sure to install the Reporting Services component during installing SQL 2005.
3-Installing SQL Server reporting services add-in.
4-You must have IIS installed on the same server you are installing SQL Reporting Services on

This is a good step by step tutorial for installing and configuring SQL 2005 Reporting Services with SharePoint 2007:
http://blah.winsmarts.com/2007-12-SharePoint_and_SQL_Server_Reporting_Services_-_Installation_and_Setup.aspx
 

---

I am too late but i will never give up

Answer 3

Hi,

I hope you are looking for: "How to: Configure SharePoint Integration on a Stand-alone Server"

Please go through the below link:
http://msdn.microsoft.com/en-us/library/bb677368.aspx


Hope this helps you

---

Raghavan