Error when deploying report to sharepoint

Question

Hi all,

 

I realy need help on this. I cant seem to deploy my reports to sharepoint.

I have a a report server on a computer and a sharepoint Moss on another computer (actually it is on a virtual server on the same computer of the report server).

The reports were created in SQL Server 2005 Business Intelligence Development.

The sharepoint site seems to be ok.

 

From the sharePoint site, when I choose the option "New Report Data Source" or when I, after uploading a report, choose the option "Manage Data Source" I get the error "Verify that the Reporting services is running and configure in sharepoint mode".

When I try to deploy the reports from Business Intelligence to sharePoint I get the error "Client found response content type of text/html; charset =utf-8, but expected text.xml"

 

Any Ideias? Is there any log file I can check for more explicit errors? If so, where are they located (I tried to find one but wasn´t able to find any, maybe looking in the wrong place!?)?

RM

 

 

 

 

 

Answer 1

Open up the SQL Reporting Services Configuration Tool, if everything shows up green go to the Sharepoint section and click on the link.

 

This should take you to the Central Admin, verify that the SQL Reporting Services section has all the right settings, this is most likely your issue.