Putting in SQL Server Reporting Providers (SSRS) 2012 built-in mode with SharePoint 2013

Business Intelligence

Putting in SQL Server Reporting Providers (SSRS) 2012 built-in mode with SharePoint 2013

bizadmin

March 1, 2023

[ad_1]

Reporting providers 2012 built-in with SharePoint 2013

On this submit I’m going to explain putting in SSRS 2012 built-in mode with SharePoint 2013. As some guys are fairly new to SSRS 2012 or SharePoint and even SSRS built-in with SharePoint, I’m explaining the scenario from scratch.

Notice: Reporting providers won’t set up on normal or specific editions

Home windows Server 2008 or later

Notice: You’ll be able to obtain Home windows Server days trial from right here: Home windows Server Free Trial | Microsoft

Notice: SharePoint 2013 is obtainable solely in 64-bit model, so that you want a 64-bit working system.

Observe the instruction beneath to start out putting in Reporting Providers 2012 built-in with SharePoint 2013:

Set up SQL Server Enterprise version:

a. Choose Database engine providers

b. Administration instruments – Fundamental

c. Administration instruments – Full

After SQL Server 2012 set up accomplished its time to start out putting in SharePoint Server 2013 Preview

a. Run SharePoint 2013 software program conditions. Please notice, if working software program conditions failed, excellent click on on “setup.exe” in set up media and choose “Run as administrator” and click on “Set up software program conditions” once more.

b. For some cause (that it isn’t clear for me!) you will have to restart your machine once more after set up of conditions accomplished. It will occur particularly while you attempt to set up SharePoint on Home windows Server 2012.

c. After restarting run setup once more and click on “Set up SharePoint Server” and full set up course of.

d. Open SharePoint product configuration wizard and choose “Create a brand new server farm”.

e. Set the database server, use put in SQL Server database server put in earlier than (anticipate setup to finish)

f. Specify Farm safety settings

g. Configure SharePoint Central Administration Net Utility

It’s higher to specify a port quantity right here in any other case it might have some conflicts with IIS default web site (port 80).

h. Finishing the SharePoint merchandise configuration wizard

i. Configuration Profitable

SharePoint is now put in and able to use.

3. Set up SSRS 2012 in SharePoint integration mode:

Choose “Reporting Providers – SharePoint” and “Reporting Providers Add-in for SharePoint Merchandise” from features-> Shared Options

Set up SQLServer2012SP1-KB2674319-x64-ENU and Microsoft SP1 for Energy Pivot (from right here: http://www.microsoft.com/en-us/obtain/particulars.aspx?id=35577), in any other case the instructions within the subsequent steps in SharePoint Server 2013 Shell will fail
Open SharePoint Server 2013 Shell in run as administrator mode and run the next instructions:

Set up-SPRSService (will set up SharePoint Reporting Providers)

Set up-SPRSServiceProxy (will set up service proxy)

get-spserviceinstance -all |the place {$_.TypeName -like “SQL Server Reporting*”} | Begin-SPServiceInstance (will begin the service)

We will additionally begin the service from SharePoint central Administration fairly than working the third PowerShell command. The next steps are additionally helpful to confirm that the service is working.

Open SharePoint Central Administration
Click on “Handle Providers on Server” within the “System Settings” group
Discover “SQL Server Reporting Providers Service” and click on Begin within the Motion column. The standing of the Reporting Providers service will change from “Stopped” to “Began”.
If the Reporting Providers service just isn’t within the record, use PowerShell to put in the service
Confirm that the service is began in “SharePoint Central Administration” –> “Utility Administration” –> “Service Functions” –> “Handle Providers on Server” and now search for the “SQL Server Reporting Providers Service” to see whether it is now configured and is working.

Create a brand new “SQL Server Reporting Providers Utility” in “SharePoint Central Administration” –> “Utility Administration” –> “Service Functions” –> “Handle Service Functions” and create a brand new “SQL Server Reporting Providers Utility”.

Specify a reputation for the appliance, create a brand new utility pool, and specify the database server title. Down beneath additionally, you will want to pick the net utility to affiliate this utility with and I used the “Home windows Authentication” for the database authentication.

Now we must always see “Experiences Library” in our website. If not, we want to verify if “Enterprise Options” in “Website Assortment” stage is activated in addition to website stage.

To take action:

Choose Website Settings-> Website Actions-> Handle website features-> SharePoint Server Enterprise Website options

To activate it in website stage we have to activate the “SharePoint Server Enterprise Website Options” in “Website Assortment” stage. To take action choose Website Settings-> Website Assortment Administration-> Website assortment features-> SharePoint Server Enterprise Website Assortment options