Skip to content

Chad's Tech

Enterprise Systems Management… ConfigMgr, Intune, PowerShell, and cookies

Menu

  • File Repository
  • Links
  • Resume
  • About

SQL Reporting Services

You are here: Home » SQL Reporting Services

ConfigMgr SSRS – UserTokenSIDs contains an error: “The trust relationship between this workstation and the primary domain failed”

A few days ago I began receiving errors when running reports in the ConfigMgr console and the web portal. The DefaultValue expression for the report parameter UserTokenSIDs contains an error: “The trust relationship between this workstation and the primary domain

Chad May 7, 2020February 2, 2021 ConfigMgr, SQL Reporting Read more

ConfigMgr Database Maintenance – 2020 edition

Steve Thompson, ConfigMgr MVP and SQL MVP, has a nice write up on using Ola’s Maintenance Solution with ConfigMgr.  It’s good stuff.  Matthew Teegarden has a follow-up article with more info and some alterations. There’s only one problem… both are

Chad March 23, 2020February 2, 2021 ConfigMgr Read more

ConfigMgr Status Filter Rule with alternate credentials

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

Chad November 8, 2017March 24, 2020 ConfigMgr, SQL Reporting Read more

SSRS Error 401.3 Access is denied

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

Chad June 20, 2016March 24, 2020 SQL Reporting Read more

ConfigMgr Reporting Services Point with complex SQL

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

Chad August 27, 2015March 24, 2020 ConfigMgr, SQL Reporting Read more

SCCM Inventory of IPAddress SkipAsSource

< 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

Chad November 5, 2014March 24, 2020 ConfigMgr, SQL Reporting Read more

A Collection of ConfigMgr 2012 Collection Queries

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

Chad June 13, 2014March 24, 2020 ConfigMgr, SQL Reporting, T-SQL Read more

ReportServerService logs not deleted

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

Chad June 11, 2014March 24, 2020 ConfigMgr, ConfigMgr 2007, SQL Reporting Read more
  • « Previous

Recent Posts

  • Fully remove the ConfigMgr client
  • Cleanup System Disk Files
  • Easy IIS log reading for ConfigMgr
  • ConfigMgr: Get primary users with email for a collection
  • Report all ConfigMgr admin console users

Top Posts

  • Azure AD join error code 8018000a
  • Using a Task Sequence Secret Value when changing a local password
  • SCCM 2012 SP1 downloads
  • SCCM backup failing with VSS error
  • Huge ReportServer database log

Tags

Azure AD BitLocker ConfigMgr DFS-R DirectAccess FRS MECM MEMCM Microsoft Intune OSD OS Deployment PowerShell SCCM Scripting Software Packaging SQL SQL Reporting Services SSRS T-SQL WaaS Windows Windows 10 Windows ADK

Categories

  • ConfigMgr
  • ConfigMgr 2007
  • Microsoft Azure
  • Microsoft Intune
  • Microsoft Windows
  • Off Topic
  • Scripting
  • SQL Reporting
  • T-SQL
  • Trackback
  • Uncategorized
  • Windows 10
  • WSUS

RSS

  • RSS - Posts
  • RSS - Comments
Copyright © 2023 Chad's Tech. All rights reserved. Theme Spacious by ThemeGrill. Powered by: WordPress.
 

Loading Comments...