?
Solved

SCCM 2012 R2 - Report Services

Posted on 2013-12-26
19
Medium Priority
?
7,465 Views
1 Endorsement
Last Modified: 2014-10-16
Good day Experts!

I am working on getting SCCM 2012 R2 setup and have the basics of it working, but having a problem the Reporting Services role.  I have installed the role without a problem but when I try to look at reports, the selection is blank.  If I try to create a report I the message "At least one report category must exist before a report can be created. Create a report folder, then try again."

If I look on my SCCM server I find the "stock" reports in C:\Program Files\SMS_SRSRP but don't see how to tie the two together. I am sure I either missed something in the setup or entered something correct.

How can I fix?  Thanks so much in advance.
1
Comment
Question by:jchauncey60
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 9
19 Comments
 
LVL 14

Expert Comment

by:JAN PAKULA
ID: 39740020
0
 

Author Comment

by:jchauncey60
ID: 39740036
Thanks for the quick response. This is what I am seeing from the log:

System.Web.Services.Protocols.SoapException: An error occurred when invoking th
 authorization extension. ---> Microsoft.ReportingServices.Diagnostics.Utilitie
.AuthorizationExtensionException: An error occurred when invoking the authoriza
ion extension. ---> System.ServiceModel.FaultException`1[[System.ServiceModel.E
ceptionDetail, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKey
oken=b77a5c561934e089]]: Value does not fall within the expected range.~   at M
crosoft.ReportingServices.Library.ReportingService2005Impl.GetItemType(String I
em, ItemType& Type)~   at Microsoft.ReportingServices.WebServer.ReportingServic
2005.GetItemType(String Item, ItemTypeEnum& Type)  $$<SMS_SRS_REPORTING_POINT><
2-26-2013 09:30:25.466+300><thread=5504 (0x1580)>
(!) SRS not detected as running  $$<SMS_SRS_REPORTING_POINT><12-26-2013 09:30:2
.466+300><thread=5504 (0x1580)>
Failures reported during periodic health check by the SRS Server <NODE>.har
is-hc-lab.com.~  $$<SMS_SRS_REPORTING_POINT><12-26-2013 09:30:25.466+300><threa
=5504 (0x1580)>
Registry change~  $$<SMS_SRS_REPORTING_POINT><12-26-2013 09:30:25.466+300><thre
d=5504 (0x1580)>
~Waiting for changes for 1 minutes  $$<SMS_SRS_REPORTING_POINT><12-26-2013 09:3
:25.466+300><thread=5504 (0x1580)>
0
 
LVL 14

Expert Comment

by:JAN PAKULA
ID: 39740048
1 Add yourself to  Operations Manager Administrators in SCOM User Roles

2 What is the health status under Monitoring -> System Status -> Site Status -> Reporting services point?

3 have you installed this

http://www.microsoft.com/en-us/download/details.aspx?id=6442

http://www.microsoft.com/en-us/download/details.aspx?id=35747
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

Author Comment

by:jchauncey60
ID: 39740065
Thanks again for the quick reply.

1.  I was already a 'Full Administrator' by my username and by group 'Domain Admins'

2. Reporting services point is Green.  The only one that is not green is 'State migration point' which is Yellow (we are not currently using this role)

3.  First link was already installed. Second link had a previous version so I upgraded

Still the same results
0
 
LVL 14

Expert Comment

by:JAN PAKULA
ID: 39740082
0
 

Author Comment

by:jchauncey60
ID: 39740096
Both SCOM and SCCM are running on the same box and from reading the articles seems like I need to create another instance for SCCM; however I am not sure how to do this without uninstalling a reinstallation.  As a side note, SCOM was installed after SCCM.

I can do the reinstall, but would love to be able to save all the data collected to this point.  Sorry for all the questions, but I am a novice with these products.
0
 
LVL 14

Expert Comment

by:JAN PAKULA
ID: 39740100
you could export the database in sql management studio

and then import it to different instance/server


http://blogs.technet.com/b/configurationmgr/archive/2013/04/02/how-to-move-the-configmgr-2012-site-database-to-a-new-sql-server.aspx
0
 

Author Comment

by:jchauncey60
ID: 39742766
Sorry for the delay, I have been working towards a solution.  I removed SCOM from the box and destroyed the associated DBs.  I uninstalled SCCM from the box and destroyed the DBs.  

I moved re-installed SCOM on a different box and so far it is working, although I have not installed Reporting role yet.

I did a fresh install of SCCM including the Reporting role and still have the same problem.  Reports are blank.

Any ideas?
0
 
LVL 14

Expert Comment

by:JAN PAKULA
ID: 39743355
1 is port 1433 open on firewall?

2 disable the firewall (temporary) and test.

3 try running SQL Server Reporting Services service as Local System, (its probably set as domain admin)  (picture attached - to access type services.msc in start run)
100.png
0
 

Author Comment

by:jchauncey60
ID: 39744101
Thanks again...so I just don't get it.  

I decided for several reasons to blow away the entire SCCM 2012 r2 server. Loaded a new OS, new SQL, new SCCM 2012 r2.  No problems during the install and still no reports!

If I go to http://localhost:/reports I am told that I don't have privs to access the site.

Firewall is turned off (for troubleshooting).

I just don't get it...
0
 
LVL 14

Expert Comment

by:JAN PAKULA
ID: 39744130
have you added this site http://servername

or if you are using https https://servername

to trusted sites in Internet explorer?

also use “Network Service” as the service identity for the Report Server web service.

Then in IIS go to the “Directory Security” tab in the properties window of both ReportServer and Report(Virtual Directories) and enable the Anonymous Access.

can you try accessing with fqdn of the server

like http://servername.domainname.com/reports

is it even asking you for credentials?

if so are you putting full domain credentials

like

domainname\username
0
 

Author Comment

by:jchauncey60
ID: 39744557
Thanks again for assisting me...not sure why M$ makes this so difficult other than to keep consultants employed.

Not being asked for UN/PW, but getting this message

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help Keyset does not exist (Exception from HRESULT: 0x80090016)
0
 
LVL 14

Expert Comment

by:JAN PAKULA
ID: 39744563
Open Reporting Services Configuration Manager

Connect to your RS server

Select 'Encryption Keys' from the left pane

Press the 'Delete' button to get rid of your encrypted content



After doing this, you will need to re-set the connection strings and stored credentials on your reports.

http://connect.microsoft.com/SQLServer/feedback/details/322557/the-report-server-cannot-decrypt-the-symmetric-key
1
 

Author Comment

by:jchauncey60
ID: 39744572
Got rid of the encrypted content but don't see how to reset the connection strings and stored credentials...sorry can you give me a pointer

Getting this message now

User 'xxx\yyy' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
0
 
LVL 14

Accepted Solution

by:
JAN PAKULA earned 2000 total points
ID: 39744609
follow that


http://technet.microsoft.com/en-us/library/ms160330.aspx


and possibly that


http://sithayuvaraj.wordpress.com/2012/07/04/application-catalog-cannot-connect-to-server-error/


Try  running IE as administrator (right click run as administrator) (does it ask you to run UAC when trying to connect to reports?)
0
 

Author Comment

by:jchauncey60
ID: 39760917
Thanks for all your help, it finally assisted me getting to the reports.  I missed a step during configuration for the reporting service.  Once I fixed that and waiting a while I had reports...thanks again so very much!!!!!
0
 

Author Closing Comment

by:jchauncey60
ID: 39760918
Very patient and helpful...hung in there with me!
0
 
LVL 14

Expert Comment

by:JAN PAKULA
ID: 39763130
happy to help :)
0
 

Expert Comment

by:vivais
ID: 40384903
Hi Guys,
I'm trying to install SCCM 2012 R2 reporting on MS SQL 2012 SP2 with comullative update 2. The reporting server version is 11.0.5058

The error is:
(!) SRS not detected as running


System.Web.Services.Protocols.SoapException: An error occurred when invoking the authorization extension. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AuthorizationExtensionException: An error occurred when invoking the authorization extension. ---> System.ServiceModel.FaultException`1[[System.ServiceModel.ExceptionDetail, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]: Value does not fall within the expected range.~   at Microsoft.ReportingServices.Library.ReportingService2005Impl.GetItemType(String Item, ItemType& Type)~   at Microsoft.ReportingServices.WebServer.ReportingService2005.GetItemType(String Item, ItemTypeEnum& Type)  $$<SMS_SRS_REPORTING_POINT><10-16-2014 20:49:43.955-240><thread=2348 (0x92C)>
(!) SRS not detected as running  $$<SMS_SRS_REPORTING_POINT><10-16-2014 20:49:43.955-240><thread=2348 (0x92C)>
Failures reported during periodic health check by the SRS Server SQL.PCMC.LOCAL.~  $$<SMS_SRS_REPORTING_POINT><10-16-2014 20:49:43.955-240><thread=2348 (0x92C)>
Registry change~  $$<SMS_SRS_REPORTING_POINT><10-16-2014 20:49:43.955-240><thread=2348 (0x92C)>
~Waiting for changes for 1 minutes  $$<SMS_SRS_REPORTING_POINT><10-16-2014 20:49:43.956-240><thread=2348 (0x92C)>

According to MS link the SCCM 2012 R2 support MS SQL 2012, am i right? pls help to solve issue.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As companies replace their old PBX phone systems with Unified IP Communications, many are finding out that legacy applications such as fax do not work well with VoIP. Fortunately, Cloud Faxing provides a cost-effective alternative that works over an…
David Varnum recently wrote up his impressions of PRTG, based on a presentation by my colleague Christian at Tech Field Day at VMworld in Barcelona. Thanks David, for your detailed and honest evaluation!
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question