SSRS subscriptions broken after migrations to 2022
We have upgraded/moved our server from sql 2016 to sql 2022. I setup the new report server and can access all the reports and refresh them manually, but the subscriptions are broken. They exist in sql (and all the jobs were created on the new sql server), but when I log into SSRS site they do not show any subscriptions.
I found a post that said that switching the Report Server Service Account from Network Service to Virtual Service could break subscriptions. The old server looks like it was Network Service. But I could not get the new SSRS to work unless I used Virtual Service.
Does anyone know what I might need to do to either get subscriptions working on Virtual Service or what might be my issue with the SSRS site not working on Network Service?
EDIT: I figured it out. Apparently our IT dept bought Standard Edition sql server instead of Enterprise and our subscriptions are all Data Driven which is only available in Enterprise edition. :( Working on figuring out how to upgrade our license to Enterprise.