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.
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.
On the Report Server Status page, verify that Report Service Status is set to Started. If it is not, click Start.
On the Database page, verify that the Report Server Mode setting is configured by using Native.
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.
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“.
Select Reporting services point and click Next.
On the Reporting services settings page, Under Reporting Services point account click Set and select New Account.
Specify the user account. In this case we will choose PRAJWALsccmadmin as account.
Click Verify and wait until you see its Successfully Verified. click Next.
Alright the reporting services point role has been installed. Click Close.
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.
Lets open the log file named srsrp.log and check the logs. The log file srsrp.log can be found in C:Program FilesMicrosoft Configuration ManagerLogs. We see that SRS webservice is running fine on the server.