chrishuffman5/analytics-ssrs-2022
skills/analytics/ssrs/2022/SKILL.md
Version-specific expert for SSRS 2022 (SQL Server 2022). Covers Angular portal redesign, TLS 1.3 support, mobile report removal, and significance as the FINAL standalone SSRS release. WHEN: "SSRS 2022", "SQL Server 2022 Reporting Services", "final SSRS", "SSRS Angular portal", "SSRS TLS 1.3".
$ install --global
skillsauthnpx skillsauth add chrishuffman5/domain-expert analytics-ssrs-2022Install this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 26, 2026, 4:31 AM25.8s1 file scanned
SKILL.md
- name:
- analytics-ssrs-2022
- description:
- Version-specific expert for SSRS 2022 (SQL Server 2022). Covers Angular portal redesign, TLS 1.3 support, mobile report removal, and significance as the FINAL standalone SSRS release. WHEN: \"SSRS 2022\", \"SQL Server 2022 Reporting Services\", \"final SSRS\", \"SSRS Angular portal\", \"SSRS TLS 1.3\".
- license:
- MIT
- version:
- 1.0.0
- author:
- christopher huffman
SSRS 2022 Version Expert
You are a specialist in SQL Server Reporting Services 2022, the most significant recent release and the final standalone SSRS release. SSRS 2022 will receive security updates through January 2033, but no successor SSRS version will be released. Future on-premises reporting is Power BI Report Server (PBIRS).
For foundational SSRS knowledge (RDL, architecture, data sources, rendering, subscriptions), refer to the parent technology agent. This agent focuses on what is new, changed, or removed in 2022.
Key Features
Redesigned Web Portal (Angular)
The web portal was rebuilt from ASP.NET to Angular:
- Improved performance and modern look
- Full-screen view for RDL reports in the portal
- Responsive navigation adapted for small viewports and mobile browsers
- Better keyboard accessibility and Windows Narrator support
TLS 1.3 Support
- Enhanced transport security for connections to the Report Server
- Disable older TLS versions (1.0, 1.1) for security compliance
- Configure via Windows Server TLS settings and SSRS URL bindings
Accessibility Enhancements
- Improved Windows Narrator support on newer Windows OS and Windows Server versions
- Accessibility bug fixes throughout the portal interface
Platform Support
- Windows Server 2022 certified
- ReportServer catalog database can be hosted on SQL Server 2022
Breaking Changes
Mobile Reports and Mobile Report Publisher Removed
Mobile reports (introduced in SSRS 2016) were deprecated in 2020 and fully removed in SSRS 2022. Organizations using mobile reports must migrate to Power BI mobile or alternative dashboard solutions before upgrading to 2022.
Comments on Reports Disabled by Default
A new advanced server property EnableCommentsOnReports was added with a default value of false. On upgrade from earlier versions, report comments are disabled and must be explicitly re-enabled:
- Open the web portal
- Navigate to Site Settings > Advanced
- Set
EnableCommentsOnReportstotrue
Pin to Power BI Feature Removed
The ability to pin SSRS report items to Power BI dashboards was removed. Use Power BI Service direct integration or Power BI Report Server instead.
Deprecated Features
- HTML Viewer and web part toolbar customization via
rc:Toolbar=false(still functional but deprecated) - HTML 4.0 renderer deprecated in favor of HTML5
Migration Notes
Upgrading from SSRS 2019
- Inventory and migrate mobile reports before upgrade
- Back up encryption key and ReportServer database
- Run SSRS 2022 setup (in-place or side-by-side)
- After upgrade, re-enable comments if needed (
EnableCommentsOnReports=true) - Verify custom extensions compile against 2022 assemblies
- Test all reports and subscriptions
Planning for PBIRS Migration
SSRS 2022 is the final standalone release. Plan migration to Power BI Report Server:
- PBIRS is a superset of SSRS; most RDL reports work without modification
- Migration is database backup/restore (low complexity)
- Starting with SQL Server 2025, any paid SQL Server edition includes PBIRS
- See
../2025/SKILL.mdfor migration details
Support Lifecycle
- Extended support ends: January 11, 2033
- This is the final standalone SSRS release -- no SSRS version ships with SQL Server 2025
- Security patches only; no new features will be added
Related Skills
chrishuffman5/kubectl
tools
VerifiedTrustedCommunity
kubectl command-line usage and scripting: kubeconfig and context management, output formats (jsonpath, custom-columns, go-template), all major verbs (get, describe, apply, delete, exec, logs, port-forward, rollout, scale, drain), workload resources, config/storage, networking, RBAC, node management, debugging (CrashLoopBackOff, ImagePullBackOff, OOMKilled), and scripting patterns (dry-run, diff, wait, jq, kustomize). WHEN: "kubectl", "k8s CLI", "kubeconfig", "namespace", "pod", "deployment", "service", "ingress", "configmap", "secret", "rollout", "scale", "drain", "taint", "kustomize". Do NOT use for cluster architecture, sizing, upgrades, or workload design decisions — that's the `kubernetes` skill in the `containers` plugin. This skill is command syntax and scripting kubectl against an existing cluster, not cluster ops.
3SKILL.mdUpdated Jul 21, 2026
chrishuffman5/bash
tools
VerifiedTrustedCommunity
Bash 5.x shell scripting, Unix text processing, and command-line automation: variables, parameter expansion, quoting, control flow, functions, I/O redirection, error handling (set -euo pipefail, trap), and the Unix tool ecosystem (grep, sed, awk, jq, find, sort, uniq, cut, xargs). Covers process management, networking (curl, ssh, rsync, nc), file locking (flock), parallel execution, and production script patterns. WHEN: "Bash", "bash", "shell", "sh", ".sh", "shell script", "sed", "awk", "grep", "jq", "find", "xargs", "curl", "ssh", "rsync", "cron", "pipe", "redirect", "here-doc", "shebang", "POSIX", "set -euo pipefail", "trap".
3SKILL.mdUpdated Jul 21, 2026
chrishuffman5/azure-cli
tools
VerifiedTrustedCommunity
Azure CLI (az) command syntax and scripting: authentication (interactive, service principal, managed identity, SSO), output formats and JMESPath queries, resource groups, VMs, storage accounts/blobs, networking (VNets, NSGs, load balancers, DNS), Entra ID, AKS, App Service, Functions, databases (SQL, Cosmos DB, MySQL, PostgreSQL), Key Vault, Monitor/alerting, and infrastructure scripting patterns. WHEN: "az ", "Azure CLI", "az login", "az vm", "az aks", "az storage", "az keyvault", "az monitor", "az ad", "az group", "az network", "az webapp", "az functionapp", "az sql", "az cosmosdb", "JMESPath", "az account". Do NOT use for Azure architecture, landing zones, or multi-subscription strategy — that's the `cloud-platforms` plugin. This skill is about command syntax and scripting the CLI, not deciding what to provision.
3SKILL.mdUpdated Jul 21, 2026
chrishuffman5/aws-cli
tools
VerifiedTrustedCommunity
AWS CLI v2 command syntax and scripting: authentication (profiles, SSO, assume-role, instance profiles), output formats and JMESPath queries, pagination and waiters, IAM, S3, Lambda, RDS, CloudFormation, ECS, EKS, CloudWatch, SSM, Route 53, STS, and VPC networking. WHEN: "aws ", "AWS CLI", "aws ec2", "aws s3", "aws lambda", "aws iam", "aws cloudformation", "aws ssm", "aws ecs", "aws eks", "aws rds", "aws cloudwatch", "aws route53", "aws sts". Do NOT use for AWS architecture, service selection, multi-account strategy, or FinOps — that's the `cloud-platforms` plugin. This skill is about command syntax and scripting the CLI, not deciding what to provision.
3SKILL.mdUpdated Jul 21, 2026