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.
Solution: Add 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."
Solution: Add 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.
http://msdn.microsoft.com/en-us/library/gg492276.aspx
http://learnsqlwithbru.com/2011/12/27/configuring-sql-server-reporting-services-in-sql-server-2012/
http://blogs.technet.com/b/configurationmgr/archive/2014/07/23/a-step-by-step-example-of-configuring-a-reporting-services-point-for-https-in-system-center-2012-configuration-manager.aspx
PS C:\Users\Administrator> Install-SPRSServicehttp://learnsqlwithbru.com/2011/12/27/configuring-sql-server-reporting-services-in-sql-server-2012/
http://blogs.technet.com/b/configurationmgr/archive/2014/07/23/a-step-by-step-example-of-configuring-a-reporting-services-point-for-https-in-system-center-2012-configuration-manager.aspx
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
Thanks! Verify helpful!
ReplyDeletebetter to do it through powershell so it writes it to all the application configs.
ReplyDelete$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()