My IT Experiences - Microsoft 365, SharePoint & Azure

Setting up Reporting Services for a SharePoint 2010 in integrated mode can be done in less than 30 minutes if you have the infrastructure ready. However there are a few things to take care of if we are in a SharePoint farm environment with different servers handling different roles. To get Reporting Services to work in SharePoint Integrated mode requires SharePoint object model. Either we install SharePoint object model on our database server running Reporting Service or install SQL Server Reporting Service on a SharePoint application server. Here are a few things to take care of: 1. Use a domain account in the Reporting Services Configuration Manager 2. In the Reporting Services Configuration Manager wizard, click on Apply in different screens before navigating away. 3. Reporting Services Add-in is required on SharePoint Servers; it is part of the SharePoint 2010 pre-requisite installer. It can also be downloaded and installed separately on SharePoint Servers. ...

We were getting this strange error while viewing our reports in SharePoint that was deployed using BIDS 2005: An error has occurred during report processing. Cannot impersonate user for data source 'datasource' Logon failed I tried many things but nothing worked. I did some research and found many blog posts which suggested me to reapply the password on the datasource file specified in the error message and save it again. That didn't work for me. I saw some check boxes in the data source file that read "Use as Windows Credentials" and "Set Execution Context to this report" and I didn't know what they meant. I unchecked those in my data source and then when the refreshed the page the report started displaying.