topic Re: PowerBI Report Server Connection to Remote Oracle Database Fails Using Kerberos in Report Server

PowerBI Report Server Connection to Remote Oracle Database Fails Using Kerberos

CJD — Fri, 06 Sep 2024 17:44:24 GMT

Running Power BI Report Server, version 15.0.1113.165

On the report server I have a connection to an Oracle database running on a remote non-Windows server in the same domain that I want to use the current user's credentials (e.g., using Kerberos). This connection fails with an invalid username/password error. It does not appear to be using Kerberos in the attempt.
Connections that specify credentials succeed.
The report server config file uses RSWindowsNegotiate.
The report server runs under a domain service account. The account is configured to allow the delegation. SPNs have been created on the service account.
I can't find anything in the logs (Windows and report server) to indicate the problem. Kerberos logging is enabled.
When logged on to the machine hosting the report server, I can use SQL*Plus to connect to the Oracle database using Kerberos so that much is working.

What am I missing to get the report server to use Kerberos?

Re: PowerBI Report Server Connection to Remote Oracle Database Fails Using Kerberos

Anonymous — Mon, 09 Sep 2024 01:59:31 GMT

In Active Directory, ensure that service accounts are trusted for delegation to Oracle services. This can be done in the Delegation tab of the service account. Also make sure that you have the correct SPN set up for the service account that is running the report server.
Make sure that the rsreportserver.config file is correctly configured to use Kerberos. The authentication type should be set to RSWindowsNegotiate. You can check this link:

Configure Kerberos to use Power BI reports - Power BI | Microsoft Learn

You also need to see if the Oracle client on the report server is configured to use Kerberos. This involves setting the appropriate Kerberos parameters in the sqlnet.ora file.
Check if there are any network issues or firewall rules blocking Kerberos traffic between the report server and the Oracle database server. You can refer to this post:

Solved: Oracle database connection error in Power BI Repor... - Microsoft Fabric Community

Now that Kerberos logging is enabled, check the logs for any Kerberos-related errors. You can also enable verbose logging for the report server for more details. Check that you're using an Oracle client version that's compatible with your Power BI Report Server. You can check the following link:

Set up the Oracle connection type with SSRS and a Power BI report server - SQL Server Reporting Services (SSRS) | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

Re: PowerBI Report Server Connection to Remote Oracle Database Fails Using Kerberos

abuislam — Tue, 10 Sep 2024 08:24:45 GMT

It sounds like you've covered most of the key points. Ensure that the SPNs are correctly registered and that the domain service account has the correct delegation settings. Also, verify that the Oracle client on the report server is properly configured to support Kerberos. Sometimes, additional settings or troubleshooting in Kerberos configuration may be needed.

Re: PowerBI Report Server Connection to Remote Oracle Database Fails Using Kerberos

CJD — Fri, 13 Sep 2024 17:00:05 GMT

Thanks for the suggestions. I went through them but did not resolve the issue.