Subscription Issues

[JessicaS]

Since migrating to SQL Server 2022, I am having multiple subscription issues where subscriptions are not created, run, and or emails are not sent. 

I see the following error messages in the logs.  

RSPortal:

Received a request with an unmatched or no authentication scheme. 401

Sending response. Response code NT AUTHORITY\SYSTEM 200

[Anonymous]

Hi @JessicaS ,

The error message "Received a request with an unmatched or no authentication scheme. 401" suggests an issue with authentication. SQL Server 2022 has introduced new properties and enhanced security features. Ensure that your Report Server is correctly configured to handle authentication schemes, especially if you've migrated from an older version. Review the new report server properties and ensure they are correctly set up as per your environment needs. More details:  Server Properties Advanced Page - Power BI Report Server & Reporting Services.

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.