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.

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,

We are running SSRS2005 in Sharepoint Integrated Mode. RS is on a separate server from the rest of our WFE in sharepoint2007. It seems all configuration items are good in RS configuration (I originally implemented in Native mode to be sure, then Configured new databases for integrated mode). Additionally I ran WSS 3.0 and configured the RS server to be part of farm. From sharepoint CA, I have configured the 3 settings that show up under Application Management > Reporting Services --under "Manage Integration Settings" we are using "Windows Authentication" mode --All seems fine in the configuration since we are able to access and manipulate the "Set Server Defaults" page and can set SSRS server settings But when we go to deploy a report we get the error belowI believe it must be an issue with the double hop from sharepoint to the RS server. Things to note: *we are using a single domain account for both the web service and windows service on RS -necessary to use domain account in our setup according to microsoft -using 1 service account for both services also OK according to microsft *we ran adsUTIL.vbs to enable NTLM authentication in IIS on the report server *sqlserver2005 sp2 implemented on all servers w/ sql components including the client deploying the report *URLs for DC library, Report Library, and Report Center all verified thru browser. Error: ------------------------------ A connection could not be made to the report server http://workspacestest.chi.ecommunity.com/sites/ReportCenter/. ------------------------------ADDITIONAL INFORMATION: Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized. (System.Web.Services)

How is this deemed an answer???? It more along the lines of giving up on a distributed report server...

Hi all I know this is an old post, but i am having the exact same issue as brettvp above - using SQL 2008 R2, Sharepoint 2007. Everything seems to be working fine with the configuration, but when i go to publish a report, i get the 401 unauthorized error. Can anyone help me resolve this please?? Thanks!

If we are using Report Server in SharePoint integration mode then in the TargetServerUrl property we have to specify the site name else it will keep on prompting the reporting services login box.For instance, if the sharepoint site name is Home then TargetServerUrl will be http://Home. Thankspankaj

Hi there, We are having this issue with the login box kept poping up when we are trying to deploy projects/reports to sharepoint.Kind Regards, J