SSRS Integrated Mode with SharePoint 2010

Configuration Steps

• Prepare the servers as SharePoint application servers and joined into the farm
• Install SSRS 2008 R2 bits on the servers
• Configure SSRS using configuration wizard
  • Create a database in integrated mode
  • Web Service URL – if Advanced button is not enabled, you need to apply the settings first and then you can change or add another DNS url later
  • Configure execution account
• If you use more than one server to run SSRS, you need to make the machine key be the same for all SSRS servers in web.config
• If you use DNS name instead of machine name for reportserver url then you need to change <UrlRoot /> to the DNS name
• If you use kerberos, then configure the following:
  • SETSPN for SSRS url such as https://ssrs.contoso.local on the SSRS service account, trust the service account for basic delegation
  • Change <RSWindowsNTLM /> to <RSWindowsNegotiate /> in rsReportServer.config
• Configure SSRS in SharePoint CA
  • Report Server Web Service URL
  • Add Report Server Instance – SSRS web and windows service accounts will be granted permission to SharePoint databases in this process

Create Reports using Report Builder

• Create a document library
• Add following content types to this document library
  • Report Data Source
  • Report Builder Model
  • Report Builder Report
• Use report builder to create reports
  • Create a Data Source
  • Create Builder Model
  • Create the Report

Create Reports using Visual Studio

• Create a report using Visual Studio
• Publish urls are different from native mode – check the reference below

References:

• https://msdn.microsoft.com/en-us/library/bb326213.aspx
• https://msdn.microsoft.com/en-us/library/bb326356.aspx
• https://fendy-huang.blogspot.com/2011/02/create-ssrs-report-with-sharepoint-2010.html
• https://blogs.msdn.com/b/psssql/archive/2011/02/24/sharepoint-adventures-why-isn-t-claims-working-with-ssrs.aspx