Report deployment error in SharePoint Integration mode

Hi,

I get the following error when I am trying to deploy Report from Visual Studio Report Designer.

SRSS is configured in SharePoint integration mode. Configuration is mentioned below.

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://rbddspsdev2:44887/.

ADDITIONAL INFORMATION:

Server was unable to process request. > The request failed with HTTP status 401: Unauthorized. (System.Web.Services)

BUTTONS:

OK

Configuration is as follows.

Web front end server.

MOSS 2007 Standard edition 64 bit.

SQL Reporting Service Add in 64 bit.

SQL Server

MS SQL server 2005 32 bit with sp2.

Reporting Services configured.

WSS 3.0 32 bit required for configuration, of SRSS in integrated mode.

Windows service and web service are both running under a domain account. The account is a SharePoint Admininstrator. The account is also in Administrators, Reporting Server user and Web service group and also has a dbo rights on database.

Hi

To publish a report to a SharePoint site configured for SharePoint integration, you must verify that the report project properties in Report Designer point to the SharePoint site. All references to servers, reports, shared data sources, and resources must be fully qualified URLs. The TargetServerURL property must be a URL to a SharePoint site. The TargetDataSourceFolder and TargetReportFolder properties must be URLs to a SharePoint library or library folder. You must have Member or Owner permission on the SharePoint site to set the properties on the project.

To publish a report to a SharePoint site

1. In SQL Server Development Studio, open an existing or new Report Server project.

2. From the Project menu, click Properties. The <project> Property Pages dialog box opens.

3. Choose the Configuration you use to publish to a SharePoint site. For example, Active(Debug) or Production.

4. In the Deployment section, for the optional TargetDataSourceFolder, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents/DataSources.

5. For TargetReportFolder, type a fully qualified URL to a library or library folder. For example, http://TestServer/TestSite/Documents.

6. For TargetServerURL, type a URL to a SharePoint top-level site or sub-site. If you do not specify a site, the default top-level site is used. For example, http://servername, http://servername/site or http://servername/site/subsite..

7. Click OK.

8. In Solution Explorer, right-click on the report you want to publish, and click Deploy. The report is published to the location specified in TargetReportFolder.

|||

Please post back if you have resolved this issue, as I have the same issue.

I have SQL 2005 sp2 as a seperate server from my sharepoint server. I was running reports in native mode and converted to integrated. I am using domain accounts for windows and web services. I have all green checks in reports configuration. If I browse to http://sqlserver/reportserver/ I get the following error:

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Get Online Help

I don't see anything in the log - but would be happy to post entries if someone can spot my error in them.

From VS 2005 when I attempt to upload a report, I get "a connection could not be made to the report server Get Online Help

I don't see anything in the log - but would be happy to post entries if someone can spot my error in them.

From VS 2005 when I attempt to upload a report, I get "a connection could not be made to the report server https://sharepointserver/

In Sharepoint configuration, when I attempt to set server defaults I get: "

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. > The request failed with HTTP status 401: Unauthorized.

Troubleshoot issues with Windows SharePoint Services. "

I would really love to get this working.

|||I get the same error in the same place.

|||

Please check rs_log# file in ...:\Documents and Settings\[USER]\Local Settings\Temp

It should contain more details about your problem.

Are you using "Windows Integrated" or "Trusted Accounts" Authentication Mode?

|||

Hi all,

My issue i guess was because of the double hop between my Reporting Server and SharePoint server. Anyways now i have Reporting Server and MOSS both on same machine and the problem seem to go away on its own.

Hope this helps other too.

Thanks,

|||Anyone an answer to this? I've seen many blogs w/ this issue but no answers.