SQL Server Case of the Week: SSRS Data-Driven Subscriptions Missing After Migration to SQL Server 2022
March 20, 2026
You migrate SSRS from SQL Server 2016 to SQL Server 2022. The reports are there. The data sources look right. The encryption key is loaded. Everything checks out until you open the web portal, and your data-driven subscriptions are gone. You can see them in the ReportServer.dbo.Subscriptions table, but the portal won’t show them. And
SSRS Data-Driven Subscriptions Missing After Migration to SQL Server 2022 -Troubleshooting Guide
March 18, 2026
If you’ve migrated SSRS to a new server and your data-driven subscriptions have disappeared, or new subscriptions are failing with a generic timeout error, this post walks through three separate issues we hit on a single migration and how we resolved each one. Data-Driven Subscriptions Disappeared After SSRS Migration to SQL 2022 Standard After migrating
Troubleshooting SQL Server Failover Cluster Instance Weirdness
November 21, 2025
Case of the Week: Quick Summary Two of the four clients’ SQL Server Failover Cluster Instances (FCIs) did not fail over to the secondary node. Context This is a SQL Server 2019 with four load-balanced FCI’s running on two physical servers with 64 CPUs, 4TB of memory, and a Pure Storage array on the backend.
Should a SQL Server DBA Know Windows Clustering?
November 5, 2025
Should a SQL Server DBA know how a Windows cluster works, and or how to create a Windows cluster, or troubleshoot a cluster? Or should we, as DBAs, stay in our lane? In some organizations, a line is drawn between what a DBA can and can’t do and the System Administrator (SA) has the Infrastructure
Curious Case of SQL Server Shutting Down Whenever a Job Runs.
October 17, 2025
This is a post in our new Case of the Week series — short write-ups from the real SQL Server issues our team of 17 SQL Server experts helps clients solve every day. Case of the Week: Quick Summary A client reported that their SQL Server service was “randomly shutting down”. They would restart SQL
SQL Just Stops When Running OPENROWSET Query
October 15, 2025
Sometimes people install Office onto a SQL Server to get the drivers for the ability to import data from Excel into SQL Server Tables. This should never be done on a production, or any, server because it can cause many other problems for SQL, one of which is the purpose of this blog. For example,
How to Setup a Standalone SSRS Server As Part of an Availability Group
August 9, 2023
SQL Server Reporting Services (SSRS) is a useful tool that can be installed on a standalone server (a license is required), or it can be installed on an existing SQL Server host (this shares the existing license of SQL Server). This blog post covers how SSRS is installed on a standalone server and how to