Deploying SCCM 2012 Part 12 – Installing and Configuring Reporting Services Point

28185

Deploying SCCM 2012 Part 12 – Installing and Configuring Reporting Services Point.

Reporting in System Center 2012 Configuration Manager provides a set of tools and resources that help you use the advanced reporting capabilities of SQL Server Reporting Services. Reporting helps you gather, organize, and present information about users, hardware and software inventory, software updates, applications, site status, and other Configuration Manager operations in your organization. Reporting provides you with a number of predefined reports that you can use without changes, or that you can modify to meet your requirements, and you can create custom reports. Configuration Manager provides report definitions for over 400 reports in over 50 report folders, which are copied to the root report folder in SQL Server Reporting Services during the reporting services point installation process. The reports are displayed in the Configuration Manager console and organized in subfolders based on the report category. Reports are not propagated up or down the Configuration Manager hierarchy; they run only against the database of the site in which they are created. You can run Configuration Manager reports in the Configuration Manager console by using Report Viewer, or you can run reports from a browser by using Report Manager. To run reports in the Configuration Manager console, you must have the Read right for the Site permission and the permissions configured for specific objects. The user account will need Modify right for the Site permission to modify the reports.

 

SQL Server Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. The reporting services point in Configuration Manager communicates with SQL Server Reporting Services to copy Configuration Manager reports to a specified report folder, to configure Reporting Services settings, and to configure Reporting Services security settings. Reporting Services connects to the Configuration Manager site database to retrieve data that is returned when you run reports.

To verify if that SQL Server Reporting Services is installed and running correctly, On the desktop, click Start, click All Programs, click Microsoft SQL Server 2008, click Configuration Tools, and then click Reporting Services Configuration Manager.

Deploying SCCM 2012 Part 12 Snap 1

In the Reporting Services Configuration Connection dialog box, specify the name of the server that is hosting SQL Server Reporting Services, on the menu, select the instance of SQL Server on which you installed SQL Reporting Services, and then click Connect.

Deploying SCCM 2012 Part 12 Snap 2

On the Report Server Status page, verify that Report Service Status is set to Started. If it is not, click Start.

Deploying SCCM 2012 Part 12 Snap 3

On the Database page, verify that the Report Server Mode setting is configured by using Native.

Deploying SCCM 2012 Part 12 Snap 4

On the Web Service URL page, click the URL in Report Service Web Service URLs to test the connection to the report folder. The Windows Security dialog box might open and prompt you for security credentials. By default, your user account is displayed. Enter your password and click OK. Verify that the webpage opens successfully. Close the browser window.

Deploying SCCM 2012 Part 12 Snap 6

Deploying SCCM 2012 Part 12 Snap 5  Deploying SCCM 2012 Part 12 Snap 7

Reporting Services Point Role : The reporting services point is a site system role that must be configured on a server with Microsoft SQL Server Reporting Services installed and running. Reporting Services Point role can be installed on a central administration site and primary sites, and on multiple site systems at a site and at other sites in the hierarchy. The reporting services point is not supported on secondary sites.

To install the Reporting Services Point role, Launch the Configuration Manager Console. Under Site Configuration, click on Sites. On the right hand side right click the Site IND and click “Add Site System Roles“.

Deploying SCCM 2012 Part 12 Snap 8

Select Reporting services point and click Next.

Deploying SCCM 2012 Part 12 Snap 9

On the Reporting services settings page, Under Reporting Services point account click Set and select New Account.

Deploying SCCM 2012 Part 12 Snap 10

Specify the user account. In this case we will choose PRAJWAL\sccmadmin as account.

Deploying SCCM 2012 Part 12 Snap 11

Click Verify and wait until you see its Successfully Verified. click Next.

Deploying SCCM 2012 Part 12 Snap 12

Alright the reporting services point role has been installed. Click Close.

Deploying SCCM 2012 Part 12 Snap 13

 

To verify that Reporting Services point role has been installed, click on Monitoring, expand system status , select Component Status and look for SMS_SRS_REPORTING_POINT.

Deploying SCCM 2012 Part 12 Snap 14

Lets open the log file named srsrp.log and check the logs. The log file srsrp.log can be found in C:\Program Files\Microsoft Configuration Manager\Logs. We see that SRS webservice is running fine on the server.

Deploying SCCM 2012 Part 12 Snap 15

 

  • Yonatan Saucedo

    reporting services server intance is blanck, sql 2012 And SCCM 2012

    Help my

    • During SQL setup for SCCM 2012 did you select default instance or named instance ??

      • Dan Rickard

        I had this same problem, because I had selected my Site Server, which didn’t have Reporting Services installed on it. I re-run, selecting the Site Database server, with SRS installed, and it worked a treat.

  • Johan Pol

    Hi Prajwal,
    Nice article..thanks..but..
    Is it possible to install the SCCM Reporting Services role on a seperate dedicated reporting server ?
    Is the only requirement on that seperate server that SSRS is installed on that server and configured to point to the SCCM prrimary SQL database ?

    • You can install a new instance of reporting services on a different server or a dedicated reporting server. SSRS is capable of using a remote SQL Server Database.

  • John kirshy

    after reporting services is up and running in sccm console and web. How do I add users to be able to access just the web site reporting portal?

  • Abdul

    Thanks Prajwal,

    Good article. This has Resolved my earlier reporting issues too.

    Thanks

  • Reza Prawirasatya

    SCCM 2012 R2 Reporting Services server instance is blank (on Server 2012 R2 Standard) with SQL 2012 SP1 on separate box (on Server 2012 R2 Standard). I know I’m not the only one that running into this issue 🙁
    I tried other solutions but it still didn’t work. Would you please assist me? Thanks.

    • The reporting services point role needs to be on the server that has the SSRS instance installed.

  • arshad

    Hi Prjwal

    i just seen you above setting & setup of Reprting service 2012 as same mine SCCM 2012 with windows 2008 R2 sql
    so i need to play around repprting service configration on SQL 2008 r2 for proxy option..?

    Please you can reply to my ticket.

    Regards,
    Arshad

  • SQLDBA346

    I’m having problem SCCM 2012 with SQL 2012 reporting service. I was trying to add Reporing service point but could not able to add reporting instance there. Drop down option in add site system role wizard is not showing reporting instance there. SCCM 2012 still not supporting SSRS 2012 ?

    • There might be multiple reasons for this :-
      1) check the DNS lookup.
      2) While installing the SQL server did you select Reporting services ? To confirm open Reporting Services Configuration Manager and check once.
      3) Have you installed Cumulative update for SQL 2012 ?

  • SQLDBA346

    Thanks Prajwal.
    I was able to add Reporting service point successfully. I can see the status of SMS_SRS_Reporting point is green in component status. But I don’t see the reports in SCCM console as well as Reporting manager URLs(SSRS). and I could not find srsrp.log in C:\Program Files\Microsoft Configuration Manager\Logs.. I’ve checked SSRS log no error there either.
    is there any other way to solve this ?

    • you will find srsrp.log file on the server where reporting services point role is installed. Where have you installed the RSP role ?

  • Neeraj

    Hi Prajwal
    Nice tutorials
    Getting this error while connecting to the reporting server

    Server Error in ‘/’ Application.
    ——————————————————————————–

    The resource cannot be found.
    Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.

    Requested URL: /Reports/Pages/Folder.aspx

    ——————————————————————————–
    Version Information: Microsoft .NET Framework Version:2.0.50727.5448; ASP.NET Version:2.0.50727.5420

    Any suggestion to resolve it

  • PavanKumar Patwari

    Hi Prjawal, I had installed Reporting Services point with the help of above guidelines but i could see errors in srsrp.log (attached the screenshot) during periodic health check by the SRS Server. Could you please check and help me out here.

    • Can you check the error messages under System Status > Component Status > SMS_SRS_REPORTING_POINT

      • PavanKumar Patwari

        It is healthy Prajwal.. No errors/warnings.

      • PavanKumar Patwari

        I could see errors in Event viewer which says below. Could you guide me what can be done to fix the reported issue.

        Log Name: Application

        Source: Report Server Windows Service (MSSQLSERVER)

        Date: 5/15/2014 2:39:56 AM

        Event ID: 117

        Task Category: Startup/Shutdown

        Level: Error

        Keywords: Classic

        User: N/A

        Computer: XXXXXXXXX.XXXXXX.XXXXX

        Description:

        The report server database is an invalid version.

        Event Xml:

        117

        2

        9

        0x80000000000000

        6999

        Application

        XXXXXXXXX.XXXXXX.XXXXX

        </Event

      • PavanKumar Patwari

        I could see SMS_SRS_REPORTING_POINT Component status reported OK when i sent you the previous response. Now I could see below warnings. could you advise on this please.

        Report server service is not running on Reporting Service Point server “XXXXXXXX.XXXXX.XXXXX”; start the service to enable reporting.

        • @Pavan – Open services.msc and check if the SQL server reporting service is running, if its not start the service.

          • Screenshot for your reference.

            • PavanKumar Patwari

              Thanks for reply Prajwal.

              the service SQL Server Reporting Services (MSSQLSERVER) is up and running however could see below errors in Event viewer. Could you please throw some light here.

              ——————————————————————————————–
              Log Name: Application
              Source: Report Server (MSSQLSERVER)
              Date: 5/15/2014 5:52:40 PM
              Event ID: 107
              Task Category: Management
              Level: Error
              Description:
              Report Server (MSSQLSERVER) cannot connect to the report server database.

              ——————————————————————————————–

              ——————————————————————————————–

              Log Name: Application
              Source: Report Server (MSSQLSERVER)
              Date: 5/15/2014 5:51:43 PM
              Event ID: 117
              Task Category: Startup/Shutdown
              Level: Error
              Description:
              The report server database is an invalid version.
              ——————————————————————————————–

  • Pooja

    Hi Prajwal, I have installed the Reporting Services point, and first it seemed to be working fine, but now it is giving me a Critical status on the Site Status and it is giving me an error in the log I am putting a screenshot in there, can you please help me out? I am not able to receive any reports.