SSRs with SharePoint Integrated mode | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SSRs with SharePoint Integrated mode

Hi all,
have any one encounter this error in SharePoint Integrated mode:
on the share point site. when i try to create Data Source it gives me error bellow in reporting service log files: w3wp!library!5!08/15/2007-07:44:22:: Call to CreateDataSourceAction(tesr333.rsds, http://sharepointserver/sites/testsite/Data Sources, False).
w3wp!library!5!08/15/2007-07:44:22:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!security!5!08/15/2007-07:44:29:: i INFO: Exception while running with elevated privileges
w3wp!security!5!08/15/2007-07:44:29:: i INFO: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
w3wp!library!5!08/15/2007-07:44:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. how can i solve it!!
thanks

Have you refer to this add-in http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/readme_rsaddin.htm

Hi Satya,
We followed that and i used that too.
My Report server currently runs under NR Server account and when i try to go on SharePoint site and try to add data source it error out. and in reporting service log i see the error i poster.
If i run my Report Server under Domian/acct it runs fine but when i try to go to http://servername/reportserver. I get error that user not found. along with Report Server has encountered a SharePoint error. —> Report Server has encountered a SharePoint error. User not found.while the user that running report server is part of Domain Admin group!!!
thanks

That sounds like accessing the system with ‘deleted’ accounts, ensure the relevant account used to connect Sharepoint with SSRS has valid privileges.
KBA http://support.microsoft.com/kb/871179/en-us fyi.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |