Reporting services in SharePoint integration mode problems

Sat, 30 Jun 2007 17:18:41 Z

Hi,

I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production.

Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message:

Code Snippet

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.SqlServer.ReportingServices2006.ReportingService2006.ListSecureMethods()
   at Microsoft.ReportingServices.SharePoint.Soap.ReportService2006.ListSecureMethods()
   --- End of inner exception stack trace ---

I get the same message when trying to deploy a report from Visual Studio to a SharePoint lib.

Some info:

- SP apppool is running under domain account a

- SSRS apppool is running under domain account b

- SP uses NTLM authentication

- SP and SSRS are running on different servers

- SSRS Configuration shows all green checkmarks

Things I tried:

- Basic authentication instead of Windows Integrated on SSRS

- NTLM only instead of Negotiate on SSRS

- Settings SPN's for SSRS, didn't help

- Checked NTFS rights on ReportingServer dir, were fine (Domain users have read/list)

Does anyone have an idea about how to solve this? Any help is appreciated.

Reporting services in SharePoint integration mode problems

Tue, 10 Mar 2009 01:40:55 Z

Hi there

Did you ever get a resolution to this problem.. I am having a similar issue..

Thanks

Ryan

Reporting services in SharePoint integration mode problems

Wed, 01 Apr 2009 05:33:44 Z

Considering this is a multi-server scenario and you do not have Kerberos setup, can you ensure you are using the Trusted Account for authentication mode in the "Manage Integration Settings" web page? Additionally, if this is SSRS 2008 can you ensure you do not have RSWindowsNegotiate in the Authentication settings for the rsReportServer.config file of the Report Server?

HTH
Prash

This posting is provided "AS IS" with no warranties, and confers no rights.

Reporting services in SharePoint integration mode problems

Thu, 02 Apr 2009 00:28:08 Z

Ours is a SQL 2005 reporting services installation and we have the "Trusted Account" set up in the sharepoint services settings.

The strange thing is that the whole setup was running just fine then after running some service packs it no longer worked, we tried everything, we rolled back the SP's to no avail.

Reporting services in SharePoint integration mode problems

Thu, 07 May 2009 01:16:33 Z

Anyone ?

Reporting services in SharePoint integration mode problems

Thu, 07 May 2009 05:59:21 Z

Hi,

Check these links

http://msdn.microsoft.com/en-us/library/cc281311.aspx
http://technet.microsoft.com/en-us/library/bb283190.aspx
http://blogs.msdn.com/sharepoint/archive/2007/08/02/microsoft-sql-server-reporting-services-installation-and-configuration-guide-for-sharepoint-integration-mode.aspx

I hope these links might be helpful for you

Rajesh Jonnalagadda http://www.ggktech.com

Reporting services in SharePoint integration mode problems

Thu, 14 May 2009 01:20:59 Z

Ok I went throught these links, these are all instructions on how to set up Reporting Services, we are having issues with an installation that was already set up and working fine, then just out of the blue stopped working and has not run since.

We can still access and run the reports just fine through the "ReportServer" link no issue.. so this does appear to be an issue with Sharepoint and not reporting services itself.

The most annoying thing is that I cannot find where the actual problem is logged. I have checked all the log files I can find.. Is it just me or is Sharepoint / Reporting Services (integrated mode) just completely devoid of any kind of logging ?

This is the sum total of the error we get.. can I turn this stupid error scren off to get something more informative ?

Go back to site

Error

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.

Troubleshoot issues with Windows SharePoint Services.

Reporting services in SharePoint integration mode problems

Fri, 29 May 2009 04:56:16 Z

Hi Ryan, I am also facing the same issue as you described above one. Do you find any solution for that. If you found please share it will be great help from you.

Reporting services in SharePoint integration mode problems

Fri, 29 May 2009 06:52:20 Z

Can you browse Central Admin directly on the machine that Central Admin is installed on? This will usually display the underlying error. If the underlying error is not displayed then you can try connecting to http://machinename to see if it will display the full error. Can you post this error message?

Have a nice day!
Feroz

This posting is provided "AS IS" with no warranties, and confers no rights.

Reporting services in SharePoint integration mode problems

Mon, 01 Jun 2009 05:28:17 Z

Hi Dreamlove

Could you please try this http? I see someone can render the report after run this KB.

Thank
EricLai [MSFT]://support.microsoft.com/kb/896861

This posting is provided "AS IS" with no warranties, and confers no rights.

Reporting services in SharePoint integration mode problems

Tue, 16 Jun 2009 02:54:27 Z

Thank you so very much Eric, we have been battling with this problem for ages and this solved it for us.. Feroz was very helpful also as this helped us realise there was something not right with the integrated authentication on the server.

Thank you both so much, you are legends !!