Forum Discussion

JessicaS's avatar
JessicaS
Regular Visitor
2 years ago

Subscription Issues

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

Subscription Issues

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.