SharePoint to SSRS , unexpected issue
May 28th, 2015 2:48am

The issue was that the RS service account had to be given sysadmin role on the DB server whilst the RS was being configured.  Have a look at

http://mosshowto.blogspot.com/2009/03/reporting-services-sharepoint-multiple.html#Step-5:-Configuration-and-test-of-the-Report-Server-on-SSRS2008SPIM for more information. 

Once configured the sysadmin role can be removed.

Free Windows Admin Tool Kit Click here and download it now
May 28th, 2015 3:41am

Hi Will,

RS service account had to sysadmin role on DB server. and we have to run the .rdl file on Report server webservices url it is working fine. But we can to run sharepoint site //xxxxxx.com/Reportname/filename.aspx then the page was loaded longtime but no reponse after some time.

and some times displayed not proper way and  also some times open the report page is perfectly. Randomly it goes like this way. 

Please check the below screen shots, if u can visible to you and let me know

what is the issue we dont understand. if you have any solution please send to us.

image2

May 28th, 2015 6:08am

Hi Ravi,

I recommend to use fiddler to track the request when viewing the report in SharePoint to see what error messages are for the request.

Does issue occur with all the reports?

To narrow down the issue scope, please test with another report in SharePoint.

Thanks,

Victoria

Free Windows Admin Tool Kit Click here and download it now
May 29th, 2015 12:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics

Hi ,

We got below error while executing SSRS report through SharePoint. 

System.InvalidOperationException: Client found response content type of '', but expected 'text/xml'.  The request failed with an empty response.    at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods()     at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname)     at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname)     at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)