Saturday 22 February 2014

Configure Reporting Services 2012 for SharePoint 2013

Step 1

SharePoint central administration, click Manage services on server in the System Settings group.
Verify the SQL Server Reporting Services Service is installed and in the Running state.

Step 2
Connect to your Central Administration
Go to Manage Service Application
And create the new service “SQL Server Reporting Services Service Application

                        
Step 3:
In site settings, click Site collection Features in the Site Collection Administration group.
The Report Server Integration Feature is active.

Sometime following error occurred in the SQL Server Reporting:
Error 1:
 Web Part Error: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type Microsoft.ReportingServices.SharePoint.UI.WebParts.ReportViewerWebPart, Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 could not be found or it is not registered as safe. Correlation ID: 27a1579c-5445-00e2-0000-0738bef219cc.

SolutionAdd the following line in the web.config file of the sharepoint web application.

<SafeControl Assembly="Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" Namespace="Microsoft.ReportingServices.SharePoint.UI.WebParts" TypeName="*" Safe="True" />

Error 2:
"The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file.  Add <add verb="*" path="Reserved.ReportViewerWebPart.axd" type = Microsoft.ReportingServices.SharePoint.UI.WebParts.WebPartHttpHandler, Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> to the system.web/httpHandlers section of the web.config file, or add <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebPart.axd" type="Microsoft.ReportingServices.SharePoint.UI.WebParts.WebPartHttpHandler, Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> to the system.webServer/handlers section for Internet Information Services 7 or later."

SolutionAdd the following line in the web.config file of the sharepoint web application.
<System.web><httpHandlers>
<add verb="*" path="Reserved.ReportViewerWebPart.axd" type = "Microsoft.ReportingServices.SharePoint.UI.WebParts.WebPartHttpHandler, Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /></httpHandlers>
And
<System.webServer><handlers>
<add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebPart.axd" type="Microsoft.ReportingServices.SharePoint.UI.WebParts.WebPartHttpHandler, Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /></handlers>

Error 3:
The content type with Id 0x010100C3676CDFA2F24E1D949A8BF2B06F6B8B defined in feature {e8389ec7-70fd-4179-a1c4-6fcb4342d7a0} was found in the current site collection or in a subsite. 
Solution: Execute the following power shell command
Enable-SPFeature -Identity E8389EC7-70FD-4179-A1C4-6FCB4342D7A0 -Url http://ssrs.domain.com -force

Error 4 : An error occurred during client rendering.For more information about this error navigate to the report server on the local server machine, or enable remote errors
Solution:
IIS Reset

Note:

If SQL Server Reporting Services is not listed in service page, configure the below link step.

PS C:\Users\Administrator> Install-SPRSService
PS C:\Users\Administrator> Install-SPRSServiceProxy
PS C:\Users\Administrator> get-spserviceinstance -all |where {$_.TypeName -like
"SQL Server Reporting*"} | Start-SPServiceInstance

TypeName                         Status   Id
--------                         ------   --
SQL Server Reporting Services... Provi... 21b26c9b-3be1-406f-929b-cc0afbb1b3ee

2 comments:

  1. better to do it through powershell so it writes it to all the application configs.

    $app = Get-SPWebApplication "https://sharepointserverurl"

    $assembly = "Microsoft.ReportingServices.SharePoint.UI.WebParts, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"

    $namespace = "Microsoft.ReportingServices.SharePoint.UI.WebParts"

    $mod = new-object Microsoft.SharePoint.Administration.SPWebConfigModification

    $mod.Name = "SafeControls"

    $mod.Path = "configuration/SharePoint/SafeControls"

    $mod.Owner = "Reporting Services Mod"

    $mod.Type = 0 #for the enum value "SPWebConfigModification.SPWebConfigModificationType.EnsureChildNode"

    $mod.Value = '' -f $assembly, $namespace

    $app.WebConfigModifications.Add($mod)

    #applying changes

    $service = [Microsoft.SharePoint.Administration.SPWebService]::ContentService

    $service.ApplyWebConfigModifications()

    $app.Update()

    ReplyDelete