Scenario: SSRS, in SharePoint integrated mode, is calling a custom web service located in the SharePoint ISAPI folder access through _vti_bin. This service is using LINQ 2 SharePoint to query multiple lists in the SharePoint WFE. A layout of the set up can be seen below. Okay, network diagrams is not my strong point! Because [...]
Archive for the ‘SSRS’ Category
SharePoint, SSRS and Kerberos
Posted: 27th July 2011 in Kerberos, LINQ 2 Sharepoint, Security, Sharepoint 2010, SSRS, Web Services0
Could not load file or assembly ‘Microsoft.ReportingServices.UpgradeScripts, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. Access is denied.
Posted: 20th July 2011 in Configuration, Sharepoint 2010, SSRSCame across the above error on all the reports served through SharePoint in integrated mode. Not sure why this happen, but you seem to be able to resolve it by restarting the reports service. Go to the Reporting Services Configuration Manager ( seen in figure below), connect to the server, then stop and start the [...]
For security reasons DTD is prohibited in this XML document
Posted: 6th July 2011 in Sharepoint 2010, SSRS, Web ServicesI received the above message on some SSRS reports when the reports were using a shared data source and accessing a custom built, SharePoint, web service, in the ISAPI folder, . However, the following error left me very confused when some of the web methods were returning the data okay and the rest were returning [...]
SharePoint Integrated Mode Report Throwing Exception rsErrorReadingNextDataRow
Posted: 1st June 2011 in SharePoint, SSRSWhile deploying reports to SSRS through SharePoint, in integrated mode I received the following error ,seen in the screen shot below: An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset StaffByDepartments. (rsErrorReadingNextDataRow) Exception from HRESULT: 0×80131904 After Google-ing about, and finding no real answer I decided to [...]
After spending quite some time trawling the internet to find that answer to the above how to replace the $ dollar sign with a £ pound sign. I found that none of the solutions fully described how to do this. Admittedly, it might just be me that’s thick though. Anyway, here’s how you go about [...]
SSRS 2008 R2 – The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel
Posted: 7th October 2010 in SharePoint, SQL, SSRSTags: Sharepoint Integration mode, SSRS
Problem: When using SQL Server Reporting Service SSRS in integration mode with MOSS you come across the following error when trying to deploy reports using BIDS to a Document Library: “The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel” This problem is cause by the fact that on a [...]
