Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In
SharePoint By Bugday > Posts > Install SQL Reporting Services 2012 in SP2013
October 02
Install SQL Reporting Services 2012 in SP2013

This post continues the previous post about SP2013:

Install SharePoint 2013 on Windows 2012

SharePoint 2013 architecture Whats New

In this post we’ll have a look at how to install and activate Reporting Services, PowerView and PowerPivot in SP2013:

1. Start the SQL 2012 installation and choose SQL Server Feature Installation:

2. Click Installation and then click New SQL Server stand-alone installation or add features to an existing installation.

3. Click OK on the Setup Support Rules page.

4. Click Install on the Setup Support Files page.

5. Click Next after the support files have completed installing and the support rules show a status of passed.

6. On the Product Key page, type your key or accept the default of the ‘Enterprise Evaluation’ edition.

7. Click Next.

8. Review and accept the license terms and click Next.

9. Select SQL Server Feature Installation on the Setup Role page and click Next

 

SQL Server Feature Installation for setup role

10. Select the following on the Feature Selection page and click next.

IC541103

11.Click Next on the Installation Rules page.

12.If you selected the Database Engine services, accept the default instance of MSSQLSERVER on the Instance Configuration page and click Next.

13. On the Disk Space page click Next.

14, On the Server Configuration page type appropriate credentials. Click Next.

15. If you selected the Database Engine services, you will see the Database Engine Configuration page, add appropriate accounts to the list of SQL Administrators and click Next.

16. On the Reporting Services Configuration page you should see the Install only option is selected. This option installs the report server files, and does not configure the SharePoint environment for Reporting Services.When the SQL Server installation is complete, follow the other sections of this topic to configure the SharePoint environment. This Includes installing the Reporting Services shared service and creating Reporting Services service applications.

rs_SQL11_SETUP_SSRS_configpage_withcircles

17. Click next.

18. Click next.

19. On the ready to install page click next.

Install and Start the Reporting Service SharePoint Service

First of all, make sure that you install SQL 2012 Service Pack 1. You need sp1 to make the BI features available in SP2013:

SQL Server 2012 SP1 CTP

1. Now start the SharePoint 2013 Management Shell as Administrator

2. Run the following command: Install-SPRSService

3. Run the following command: Install-SPRSServiceProxy

4. Run the following command: get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance

5. In Central Admin, make sure that the SQL Server Reporting Service is started:

image

6. Create a new SQL Server Reporting Service Application:

image

7. Now let’s publish a report to a SharePoint 2013 libray:

image

8 The published report in SP2013:

image

Have fun, and stay tuned for the next post on how to setup PowerPivot in SP2013 using SSAS 2012.

 

 

Comments

Problem ssrs et sharepoint

Edit
 i have sql server express 2012 and sharepoint  foundation 2013
i wnat to add a ssrs report in sharepoint but i can't
the probleme is :
" The feature: "Windows SharePoint Services integration" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Windows SharePoint Services integration" is not supported in this edition of Reporting Services."
please help me
 on 6/2/2013 9:59 PM

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Title


Body *


E-Mail *


TodayIs *


What's today's abbreviated value(DDD)

Attachments