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

46
Leave a Reply

avatar
18 Comment threads
28 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
newest oldest most voted
Tom
Guest
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
Guest
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
Guest
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
Guest
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
Guest
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
Guest
Ahmad Amin

i have the same issue

CarlosA
Guest
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?

Simon
Guest
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
Guest
Simon

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

Sultan
Guest
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
Guest
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
Guest
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.

James Vincent
Member
James Vincent

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

PavanKumar Patwari
Guest
PavanKumar Patwari

It is healthy Prajwal.. No errors/warnings.

PavanKumar Patwari
Guest
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
Guest
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.

James Vincent
Member
James Vincent

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

James Vincent
Member
James Vincent

Screenshot for your reference.

PavanKumar Patwari
Guest
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
Guest
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
Guest
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
Guest
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
Guest
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
Guest
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
Guest
Abdul

Thanks Prajwal,

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

Thanks

John kirshy
Guest
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
Guest
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 ?

Yonatan Saucedo
Guest
Yonatan Saucedo

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

Help my

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