Reporting Services In SharePoint Integration Mode Problems

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.