I gues as many times your subreport is called ( the distinct values?) + 1 for the main report

Not sure if it's related but occasionally we have corrupt subscriptions. Those have a double datasource

check

select 
DataSource.DSID DatasourceID
,DataSource.Name DatasourceName
,Subscriptions.[SubscriptionID] SubscriptionID
,Subscriptions.Description SubscriptionName
,Reports.Name RerportName
,Reports.Path ReportPath
from [ReportServer].[dbo].[DataSource] DataSource
left join [ReportServer].dbo.Subscriptions...

Thanks for the start article. Installed the libraries from the resources in the SSRS GAC. Also copied them to ReportServer\bin folder.

Todo: reportbuilder

Mixed feelings about the logging. Sometimes it's just "Unexpected termination".

Wow, running sql server 2005. Maybe it's better to setup a new 2019 and restoring the data. TLS 1.0 en 1.1 are getting obsolete fast.

Regarding linked server: did it work...

MS knows the answer and MS can vouch for it. Best route is to contact MS

As far I can read is that if you have SA (subscription) you're allowed one...

Lately there was some visibility because of an Apple OS bug. We've found a rather annoying bug that allows remote takeover, patch asap

And the implemented solution is / was?

That's why we are still using VM's. Containers / K8 are next level in management

I'm not familiar with AAG groups or replica's.

As you're working with AAG's you might get funding for a MS support call / consultant to sort it out

I would also go on the route of permissions. Perhaps you're not seeing all the files. (difference between user and "run as administrator")

Ask the vendor of the tool for help?

Is the database "offline" or the folder "" offline?

Have you tried fiddling with the folder permissions ( perhaps the tool, sql server, your...

No, SSAS keeps the memory as it is usefull for caching. It will try to keep a minimum of free memory on the server. When lowmemory is triggered, start cleaning...

We only have one server with one catalogue.

We use it to override settings that may come from deployments. New project -> Configure -> Link to environment. You may not need...

Retry logic in SQL is difficult as there may be errors that kills your session. You could use try catch but it's still tricky

https://www.brentozar.com/archive/2022/01/error-handling-quiz-week-making-a-turkey-sandwich-with-xact_abort/