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

Reporting providers 2012 built-in with SharePoint 2013

On this put up 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.

Observe: Reporting providers won’t set up on customary or specific editions

• Home windows Server 2008 or later

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

Observe: SharePoint 2013 is out there solely in 64-bit model, so that you want a 64-bit working system.

Observe the instruction beneath to begin putting in Reporting Companies 2012 built-in with SharePoint 2013:

1. Set up SQL Server Enterprise version:

a. Choose Database engine providers

b. Administration instruments – Primary

c. Administration instruments – Full

1. After SQL Server 2012 set up accomplished its time to begin putting in SharePoint Server 2013 Preview

a. Run SharePoint 2013 software program stipulations. Please observe, if operating software program stipulations failed, good click on on “setup.exe” in set up media and choose “Run as administrator” and click on “Set up software program stipulations” once more.

b. For some motive (that it isn’t clear for me!) you might have to restart your machine once more after set up of stipulations accomplished. This can occur particularly if 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 (look forward to setup to finish)

f. Specify Farm safety settings

g. Configure SharePoint Central Administration Internet Utility

It’s higher to specify a port quantity right here in any other case it could 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 Companies – SharePoint” and “Reporting Companies Add-in for SharePoint Merchandise” from features-> Shared Options

1. 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
2. Open SharePoint Server 2013 Shell in run as administrator mode and run the next instructions:

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

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 moderately than operating the third PowerShell command. The next steps are additionally helpful to confirm that the service is operating.

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

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

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

Now we should always see “Stories Library” in our web site. If not, we’d like to ensure if “Enterprise Options” in “Website Assortment” degree is activated in addition to web site degree.

To take action:

• Choose Website Settings-> Website Actions-> Handle web site features-> SharePoint Server Enterprise Website options

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

• Now go to Website Contents-> add an App -> Report Library
• OK. It’s carried out now.[1]

[1]Reference: http://denglishbi.wordpress.com/2011/07/22/configuring-sql-server-denali-reporting-services-sharepoint-2010-integration/