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

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 PRAJWALsccmadmin 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 FilesMicrosoft Configuration ManagerLogs. We see that SRS webservice is running fine on the server.

Deploying SCCM 2012 Part 12 Snap 15

 

Related Posts
guest
46 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
Tom

hi, we already had reporting services configured and up and running. No i added SSL to the reporting services that run on our sql server, but in configuration manager, it always tries to load the http:// . How to tell configmgr to use SSL there?
Report manager and report server Link (in Monitoring->Reporting page) give me a http:// adress. When i remove the port 80 on the reporting sever config and restart configmgr, i don’t get reports anymore, as the links are still trying to connecto 80 instead 443 :-/

Joseph

I had the same issue, I re-installed SQL Reporting Services and the reporting services role. During re-installation of SSRS, I removed http in Reporting Services Configuration Manager and bound the SSL cert to port 443. Next I reinstalled the reporting services role, all the reports re-populated and no longer getting the http:// in the srsrp.log. When clicking on the reporting tab in configuration manager, the default URL is also updated to https://

Kiran khaire

Hi Prajwal,

When I am trying to connect Reporting services configuration connection to the server name it is giving me provider load failure error and instance is grayed out.
We have reporting service role enabled on this server and it was working fine earlier.

Katrina Capocelli

i followed your step by step guide, very thorough, so thank you. I am able to see the folders in my Reports view, before I wasn’t…however there is no reports showing. in the SRSRP.log, it shows the following: (!) Error deploying report [Apple Volume Purchase Program apps for iOS with license counts]. SMS_SRS_REPORTING_POINT 2/28/2019 2:46:46 PM 1824 (0x0720) Created folder [Vulnerability Assessment]. SMS_SRS_REPORTING_POINT 2/28/2019 2:46:46 PM 1824 (0x0720) System.Web.Services.Protocols.SoapException: Error while loading code module: ‘SrsResources, culture=neutral’. Details: Could not load file or assembly ‘SrsResources, Culture=neutral’ or one of its dependencies. The system cannot find the file specified.~ at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report,… Read more »

kevin lane

Hi i’ve been following your tutorial however when i’m now coming to add the role again under the specify reporting services role, on the verify database name its telling me that the specified database is not a configuration manager database ?? any ideas ?

Ahmad Amin

i have the same issue

CarlosA

I’ve Installed SCCM 2016 Current Branch with SQL Server 2017. Everything works fine except for Reporting Services Point. It Installs correctly on Both SCCM and SQL Server. All instances are fine but when i open http://server/Reports all i get is the ConfigMgr_001 and ConfigMgr_Old folders with no reports on it. After a while the component status changes to Critical.

Can you help me with this?

CarlosA

Hello,
The Reporting Services Point Installed Successfully (It was Installed on the SQL Server). After a while it shows the following message:
The report server service is not running on Reporting Service Point server “XXX.XXX.LOCAL”; start the service to enable reporting.

I find it strange because i see SQL Server Reporting Services Running. On SCCM I get a lot of 7402 Errors and if i open SQL Server Reports Site i can see the folder “ConfigMgr_001” empty with two Connection String Files, and i also see a lot of “CongifMgr.OLD” folders and all of them are empty.

CarlosA

Reporting Services Point is installed with no problems, but after a while it shows a critical status. On the Alerts it shows error 7402 and that SQL Server Reporting Services isn’t started, but in fact it is.

CarlosA

I’m planning on reinstalling the Reporting Services in the Database Server. Could it be a WMI Issue? I don’t see sccm populating the ConfigMgr Folder.

CarlosA

What log should i look for? Can you help me with this issue?

CarlosA

I Found this on the Reporting Services Service Log:

library!ReportServer_0-2!2958!03/14/2018-10:13:21:: i INFO: Call to CreateFolderAction(ConfigMgr_001, /). User: NT AUTHORITY\SYSTEM.
library!ReportServer_0-2!2d18!03/14/2018-10:13:21:: i INFO: Call to GetDataSourceContentsAction(/ConfigMgr_001/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}). User: NT AUTHORITY\SYSTEM.
library!ReportServer_0-2!2d18!03/14/2018-10:13:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘/ConfigMgr_001/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}’ cannot be found.;
library!ReportServer_0-2!2958!03/14/2018-10:13:21:: i INFO: Call to CreateDataSourceAction({5C6358F2-4BB6-4a1b-A16E-8D96795D8602}, /ConfigMgr_001, True). User: NT AUTHORITY\SYSTEM.

CarlosA

Yes it is Installed without issues as far as i can see. I see some errors on srsrp.log on the SQL Server (It is a standalone SQL Server for this deployment). Created folder [ConfigMgr_001]. SMS_SRS_REPORTING_POINT 14/3/2018 10:49:44 a.m. 5772 (0x168C) Creating data source {5C6358F2-4BB6-4a1b-A16E-8D96795D8602} at ConfigMgr_001 SMS_SRS_REPORTING_POINT 14/3/2018 10:49:44 a.m. 5772 (0x168C) Creating data source {39B693BB-524B-47DF-9FDB-9000C3118E82} at ConfigMgr_001 SMS_SRS_REPORTING_POINT 14/3/2018 10:49:44 a.m. 5772 (0x168C) Service ‘SQLSERVERAGENT’ is already Stopped SMS_SRS_REPORTING_POINT 14/3/2018 10:49:44 a.m. 5772 (0x168C) Delete old SCCMErrorResources folder SMS_SRS_REPORTING_POINT 14/3/2018 10:49:44 a.m. 5772 (0x168C) Could not find a part of the path ‘C:\SCCMErrorResources’. SMS_SRS_REPORTING_POINT 14/3/2018 10:49:45 a.m. 5772 (0x168C)… Read more »

Simon

Thanks for the guide…. My SRSRP doesn’t want to install correctly. Reporting Server (SQL) is fine, both urls are browsable. On the outside, the installation seems to go well. But when you check the Reports in SCCM you see they’re not there. Then checking the Report Server (SQL) you can see the Config_XXX folder is missing. Looking at the SRSRP logs, which for some reason have decided to install on the M:\ (Why is this and hold do I select a different path?) it clearly states it’s having trouble registering srsrpserver.dll as it can’t be found in the SMS_SRSRP folder.… Read more »

Simon

I’m running SQL Standard 2012 SP3 and SCCM Current Branch

Sultan

Hi Prajwal Desai,

Thank you for the article, very helpful.

Can you please let me know the requirement for the service account for the reporting service, does it need to be local admin or not?

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.

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.

Prajwal Desai

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.

Prajwal Desai

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

Prajwal Desai

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.
——————————————————————————————–

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

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 ?

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 ?

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

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.

Abdul

Thanks Prajwal,

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

Thanks

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?

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 ?

Johan Pol

Hi thanks for your answer…is it also possible for a named instance ?

Yonatan Saucedo

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

Help my

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.

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More