Help with setting up Reporting Services

I am trying to set up Reporting Services. I am using SQL Server 2005.

I installed service pack 2 for SQL Server 2005. The database looks to be set up in the configuration manager. When I try to deploy the report I get the following message:

A connection could not be made to the report serverhttp://localhost/ReportServer

When trying to open the ReportServer folder in IIS I get another message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Exception has been thrown by the target of an invocation.
Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

I am not sure what SharePoint is and why I need it. I am just trying to set up simple reports on a local host SQL database and IIS on a standalone PC.

Any help appreciated.

Thanks

This is just a guess. In the IIS admin tool in Control Panel/Administrative Tools, check the Properties on the Reports (and ReportServer) virtual directories under Default Web Site and make sure they are set to the Application pool "ReportServer" (or "DefaultAppPool" if there is no ReportServer pool) and not "MSSharepointAppPool".|||This probably has something to do with the Sharepoint integration that is a part of sp2. You can run Reporting Services in Integrated Mode (instead of Native Mode), and it will synchronize your report directory in Reporting Services with a site in MOSS or WSS. If you don't want to use this, ensure you are in Native Mode. Go to Microsoft SQL Server 2005 --> Configuration Tools --> Reporting Services Configuration. Then click on the tab "Database Setup". If you've installed sp2, you will see a line called "Server Mode:".|||

I recently installed SQL Server 2005 SP2 and I'm receiving this same error.

When I bring up the Reporting Services Configuration tool, and go to "Database Setup" as you say, I do in fact see a "Server Mode" line and it's set to "SharePoint Integrated".

How do I turn this off / fix the problem?

Thanx for any help in advance.

|||

I found my answer here:http://msdn2.microsoft.com/en-us/library/bb326407.aspx