Cannot Deploy Report - Please Help

I am trying to set up Reporting Services. I am using SQL Server 2005 on Win XP Pro.

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 server http://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

Hi Troy23

I don't know if this will help but change the http://localhost/reportserver to http://ipaddresss/reportserver or http://servername/reportserver.

Hope it helps,

Kind Regards,

Joos Nieuwoudt

|||

What is the value for "Server Mode" in the RS Config. tool's "Database Setup" tab?

thanx,
Prash

|||

Prash

Many thanks for your reply. I had the check box for 'SharePoint' ticked. I unticked it and set a few permissions and it worked.

I would like to ask the difference between writing a simple report with report builder and using the report model. I presume there is more to it than the fact it can be utilised on a web server.

Thanks

|||Hi, Your IIS is telling you, or certainly think you have sharepoint installed and you installation of Reportsserver is no longer valid, we sometimes get corruption sin installs, your best bet is remove all instances of Sharepoint, If you can find it? if not dont worry just go to SQL install and remove all instances of report server and then re-install from scratch, this will sort out your issues, Make sure you do a proper reboot in between remove and re-install.

Andy|||Report Builder reports must be written against a report model. You cannot use Report Builder directly against a SQL database (for example). You must create a model for the database. You can do so in Report Manager, in Business Intelligence Development Studio or in Management Studio. Hope this answers your question.