Reporting services in SharePoint integration mode problems

Question

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.

Answer 1

Hi there

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

Thanks

Ryan

Answer 2

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.

Answer 3

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.

Answer 4

Anyone ?

Answer 5

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

Answer 6

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.

Answer 7

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.

Answer 8

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.

Answer 9

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.

Answer 10

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 !!