A few days ago I began receiving errors when running reports in the ConfigMgr console and the web portal.
|
1 |
The DefaultValue expression for the report parameter UserTokenSIDs contains an error: "The trust relationship between this workstation and the primary domain failed". (rsRuntimeErrorInExpression) |
A few other very generic errors were displayed as well, but this one was the most prevalent and detailed (if
A recent customer wanted an automated SSRS Report Email Subscription anytime a new deployment was created. I’d been pondering how do accomplish that for some time, but finally got a catalyst and a bit of time. I found a PowerShell
So, you’ve been denied! It’s OK. It happens to the best of us. Server Error in ‘/Reports’ Application. Access is denied. Description: An error occurred while accessing the resources required to serve this request. You might not have permission to
In a new ConfigMgr 2012 R2 SP1 environment the Reporting Services point was proving a bit challenging to install. After setting all of the required permission it was finally happy. Required Permissions On the SQL Server Reporting Services server, an
< div class=”ExternalClass16EB91745BFA419384C0E3307E72D388″> With some guidance from Microsoft TechNet, Edward at StackOverflow.com, and Adam at RedThree, I managed to enhance the Compliance 5 – Computers in a Collection report by separating each computer onto its own page. When exported to
< div class=”ExternalClass56053B2187DC429B993BBB746BA0DCAD”> A customer of mine was looking for a way to verify that servers with multiple IP Addresses (mostly web severs) were configured to use a specific IP for all default communications. SkipAsSource is a Boolean flag which
Tommy Gunn started a great post on this same topic at SystemCenterCentral. I’m adding my own here. *note: these are WQL queries for ConfigMgr/SCCM collections, but all will translate to T-SQL queries for reporting. Computers which are joined to a
I was performing some initial discovery on a SCCM primary site server and noticed a lack of disk space. Using WinDirStat.exe I started digging deeper and discovered almost 100gb of ReportServerService_<timestamp>.log files. These are associated with the SQL Server Reporting