SOLVED No Reports displayed for one user

[lorencarter]

I am an Administrative level user in the SCCM world here, current lease level 1710, on 2016 Server, SQL world is on another 2016 Server. One site only.

When I go to the CM via RDP, I do not see any reports listed in the Monitoring, Reporting, Reports view. My account is is configured with
"Full Administrator" access. We even tried to add my regular AD user account, to see if the issue was somehow some issue with my elevated AD user account. Sadly neither account can see reports.

The strange part is that others, in fact everybody else can see and run the reports, just not me and my accounts. Searching the web, I don't see any other 2016 reports like mine. No errors are shown, there's just nothing displayed in the list of reports when I try using my account(s).

Any and all thoughts will be appreciated.

Thanks, Loren Carter. Montgomery College

Sorry Newbie mistake, this ought to be in the Configuration Manager Forum, not here

 

[Prajwal Desai]

Quick one - Can you open the SSRS by IE on the workstation? http://<SQL Reporting Server>/ReportServer

 

[Garth]

Make sure that the firewall is open on port 80 too.

 

[lorencarter]

There are no firewalls in play between my CM and the SQL Server.
From my Win7 desktop, I can open the ReportServer after giving it credentials, from the ConfigMgr console, I give it the same credentials, but nothing ever appears. I get a blank screen.
From the SQL console, it opens quickly.

 

[Garth]

So to be clear it is working from the SSRS website? Until it work there, there is no point at looking at the CM console. Again, you shouldn't have to provide credentials , if everything is setup "correctly" and your security team hasn't gone nut on browser settings. aka prevent automated logon for intranet zone.

Also remember that is it port 80 from your computer to SSRS server and not from CM site server to SSRS.

 

[lorencarter]

OK, found the problem(s). When I attempted to open the ReportServer from a browser, things were good, saw the reports. When I attempted to actually run one, I got the result that it failed since my Log_Backup on the report server was horrendously bloated. 250+GB bloated! Got that shrunk down to something mangeable. Then the reports ran through the browser.
Next onto their non-appearance in SCCM CM, I notced that my Admin level AD account had been placed into an AD group named "Protected Users". Why me and me only? No idea, but it was not causing me any day-to-day grief, until......I wanted to view and run reports with the GUI in SCCM. They still did not work after the log file "fix", but as soon as I took myself out of that group, the reports appeared and I can run them all I want.
Thanks for the feedback with the attempts to assist.

 

[Garth]

You must have you SSRS db in full recovery mode. It should be set to simple recovery.
https://www.enhansoft.com/blog/neve...abase-in-full-recovery-model-without-a-backup

 

[lorencarter]

I learned that you are correct. I did not build this, I only get called upon when things "break", and it has to get fixed NOW!!! I'm not real SQL schooled, but it will be left in Simple Recovery mode after today.
thanks