Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Kerberos Authentication w/SQLServer Linked Server (Oracle)

James G KJul 13 2017

Hi Community,

I have been struggling with getting Kerberos Authentication working with an Oracle database (11.2.0.4) on a RHEL machine, paired with an MS SQLServer Linked Server as the client. We do our reporting with SSRS, and so connect to our Oracle databases via linked server (w/ODAC Driver).

Kerberos Authentication is working fine when I pull a ticket manually and use a client like sql*plus on another linux machine. For the Linked Server which is on a Windows machine, I'm hoping to use the Kerberos ticket cached during login (Active Directory). Does anyone here have experience using Kerberos with a Microsoft Linked Server? I think there is a double-hop authentication issue we need to work through - any guidance would be appreciated. I have been referring to Master Note 1375853.1 and it's links, and have combed google for answers.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2017

Added on Jul 13 2017

#database-security, #database-security-general

0 comments

319 views