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?