How is the vendor providing that data?  Is this through a linked server - a file that...

There was a migration?  Or just an in-place upgrade of everything?  It isn't clear - but it sounds like you have a new server and that server may be blocked.

When you say you upgraded SQL Server - what exactly was upgraded?  Did you upgrade SSRS only - or also the database engine?  Is this an all-in-one SSRS instance where...

If you look in the services applet - what do you see there?  Is SQL Server in a starting or stopping state?

Next thing to do is check the SQL logs...

We have links in our signatures that show how to do that, but simply put:

Insert Into someTable (col1, col2)
Values (val1, val2), (val3, val4), (val5, val6), ...

On the table ConvoHrs - why are both columns defined as varchar(200)?  If you can have anything put into those columns - then that is what will happen and you...

You cannot use a column alias here - SQL Server doesn't know anything about those aliases until after the select portion has been processed.

There are further problems with this code...

How is event_sec stored in the database?  Is it stored as an actual time - or is it stored as a duration?  If stored as a duration - then all...

What dependencies do you have set for SQL Server?  Review this article: https://blog.waynesheffield.com/wayne/archive/2018/02/using-gmsa-sql-server/

In order for a connection to be redirected to the read-intent secondary, the connection string must include the ApplicationIntent and the database that exists in the AG.  If either do...

If the activity monitor is pausing after a timeout - you probably have run into a bug with the code provided by Microsoft to populate the data.  There is a...

Why are you only joining on packageId - when both tables have packageId and partId?  If you join only on one part of the key - then you will get...

I find it interesting that some think SSIS is a DBA tool - and others believe it is a developer tool - and yet others think in is strictly a...

Here is the documentation on report parts: https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-parts-report-builder-and-ssrs?view=sql-server-ver15

Essentially - this is a way of publishing just a part of a report that can be reused in other reports.  So, instead...

I would not use a single project for all reports - like Brian I would create separate projects that are separated either by folder or by type.

There are other reasons...