Report Server error connecting to Oracle data – failed to create windows identity for user

Report Server error connecting to Oracle data – failed to create windows identity for userFollow
James Watts
James WattsNov 09, 2022 08:45 AM
Just published to the web service a paginated report that pulls data from an on premise Oracle database. …
1. Report Server error connecting to Oracle data – failed to create windows identity for user

Bronze Contributor
James Watts
Posted Nov 09, 2022 08:45 AM
Just published to the web service a paginated report that pulls data from an on premise Oracle database. Works fine in the desktop Report Builder app. However, on the web service it is coming up with the following error:

Could not connect to the data source.
A data source used by this report returned an error. If you continue to experience this error contact the report author or data source owner quoting: DM_GWPipeline_Gateway_ImpersonationError. Failed to create windows identity for user <pi>powerbi.admin@chrysaor.com</pi>.

Has anyone come across this before? Any ideas how to resolve it? I’ve seen somethings online about constrained delegation, but it is all over my head.

FYI, the gateway is working perfectly for Power BI dashboards, including to the Oracle database the paginated report uses.

——————————
James Watts
Business Intelligence Analyst
——————————

2. RE: Report Server error connecting to Oracle data – failed to create windows identity for user

Bronze Contributor
James Watts
Posted Nov 09, 2022 10:41 AM
I think I may have found the solution – disabling ‘connect using Kerberos’ for DirectQuery. I assume Report Server uses direct queries, and as we are using a Basic authentication for the Oracle source, Kerberos is not needed.

——————————
James Watts
Business Intelligence Analyst
——————————

3. RE: Report Server error connecting to Oracle data – failed to create windows identity for user

Bronze Contributor
James Watts
Posted Nov 17, 2022 08:43 AM
Well, that fixed the test environment, but the prod environment (which is different for several good reasons), is now reporting the following when opening a report that contains an Oracle data source.

Unable to render paginated report
Could not connect to the data source.

Any suggestions please ?

——————————
James Watts
Business Intelligence Analyst
——————————