topic Error in Report Server

Error

Anonymous — Fri, 19 Nov 2021 19:35:26 GMT

I am trying to access this website ConsultsByOrderDate - Power BI Report Server (va.gov)

I am getting the error

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)

The target principal name is incorrect. Cannot generate SSPI context.

Re: Error

d_gosbell — Sun, 21 Nov 2021 22:07:08 GMT

You will need to contact the IT helpdesk at va.gov for this issue. This is not really something we can help with on the public community forums, it looks like you possibly do not have the correct permissions to the source data.

Re: Error

Icey — Fri, 26 Nov 2021 02:47:50 GMT

Hi Anonymous ,

Has your device installed the Windows OS patch released on November 9th, 2021? It may impact Kerberos delegation.

Reference: Windows 10, version 1809 and Windows Server 2019 | Microsoft Docs

Resolution: This issue was resolved in the out-of-band update KB5008602 released November 14, 2021. It is a cumulative update, so you do not need to apply any previous update before installing it. To get the standalone package for KB5008602, search for it in the Microsoft Update Catalog. You can import this update into Windows Server Update Services (WSUS) manually. See the Microsoft Update Catalog for instructions. Note KB5008602 is not available from Windows Update and will not install automatically.

Please check if the above solution work for you.

If not, please try this:

Delegation setting for the SSRS/PBIRS service account is set to constrained delegation: "Trust this user for delegation to specified service only" --> "Use any authentication protocol".

Best Regards,

Icey

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