Share via

SSRS not connecting to Oracle DB using Encrypted connection (Oracle NNE)

Dunkley, Scott 11 Reputation points
2025-10-29T10:43:23.23+00:00

Hi,

We have setup Oracle NNE on our DB's to encryot our sessions. this is working fine for all connections except those coming from reportingservices.exe.

I can SQLplus to the oracle db from the SSRS server and it connects using encryption but when setting up a datasource in the SSRS web console and testing it only connects using non exncrypted connection.

I have tried updating the machine.config file on the SSRS server but i dont think this is the right config file.

DB side I have this in SQLNET.ora:

SQLNET.ENCRYPTION_CLIENT=REQUESTED

SQLNET.ENCRYPTION_SERVER=REQUESTED

SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128)

SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128)

SSRS Server side I have this in machine.config file:

<oracle.manageddataaccess.client>

<version number="*">

  <settings>

<setting name="tns_admin" value="e:\oraclebase\product\12.1.0\client\network\admin" />

   	<setting name="SQLNET.ENCRYPTION_CLIENT" value="REQUIRED" />

<setting name="SQLNET.ENCRYPTION_TYPES_CLIENT" value="AES256,AES192,AES128" />

<setting name="SQLNET.ENCRYPTION_SERVER" value="REQUIRED" />

<setting name="SQLNET.ENCRYPTION_TYPES_SERVER" value="AES256,AES192,AES128" />

  </settings>

</version>

</oracle.manageddataaccess.client>

Datrasource is defined as Oracle Database:

DATA SOURCE=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = foaukl1npdb-swdo8-scan.emea.hays.loc)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = iepp_service.otchukl1npexcl.otchukl1npvcn01.oraclevcn.com)))

There must be a config file I am missing somewhere on the SSRS side that will tell the connections to use NNE? ANy idea where that is?

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

0 comments No comments

Answer recommended by moderator
  1. Akhil Gajavelly 1,725 Reputation points Microsoft External Staff Moderator
    2025-10-30T02:11:44.4266667+00:00

    Hi @Dunkley, Scott ,

    You’ll need to put those Oracle encryption settings in the Oracle.ManagedDataAccess.dll.config file instead of machine.config. Path:

    <SSRS Install Dir>\ReportServer\bin\Oracle.ManagedDataAccess.dll.config

    If it’s not there, create it and add your <oracle.manageddataaccess.client> section. After saving, restart the SSRS service so it picks up the changes. Also make sure the SSRS service account has the TNS_ADMIN variable set to your Oracle client’s network\admin folder.

    That should make the SSRS connections use the encrypted (NNE) session.

    Thanks,
    Akhil.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.