Forum Discussion

amoren's avatar
amoren
Frequent Visitor
1 year ago
Solved

Windows AD Authentication to Oracle Datasource from Fabric Fails

We have some Oracle 19c datasources that use Oracle CMU for AD authentication to them.  When we use PowerBI Desktop to create a report it connects fine to the datasources.  However when we publish th...
admin
security
  • amoren's avatar
    amoren
    1 year ago

    Solved.

    We had to enable SQLNET settings in our sqlnet.ora file referenced by OCMT running on the gateway.

    e.g.
    SQLNET.AUTHENTICATION_SERVICES= (<our approved auth sources>)
    SQLNET.KERBEROS5_CC_NAME = OSMSFT://
    SQLNET.KERBEROS5_CONF="<Path to our krb5.conf>"

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi amoren ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily. 

 
Thank you. 

amoren's avatar
amoren
Frequent Visitor
1 year ago

Solved.

We had to enable SQLNET settings in our sqlnet.ora file referenced by OCMT running on the gateway.

e.g.
SQLNET.AUTHENTICATION_SERVICES= (<our approved auth sources>)
SQLNET.KERBEROS5_CC_NAME = OSMSFT://
SQLNET.KERBEROS5_CONF="<Path to our krb5.conf>"