SSRS 2016 64Bit Report Manager giving the 'ORA-12154: TNS:could not resolve the connect identifier specified' After migration RRS feed

  • Question

  • We are in the process of migrating from SSRS 2008 to SSRS 2016.

    SSRS 2008 is on Windows 2008 64bit server. SSRS 2016 is on Windows 2016 server. After the new SSRS 2016 instillation, on the 2016 Report Manager, Following error message is coming when performed the "Test Connection" ORA-12154: TNS:could not resolve the connect identifier specified'

    Connection Type: Oracle Database

    Connection String:  SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=scan-server.xyz.org)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME = Database.xyz.org)))

    Note: I can use the same connection string in SSRS 2008 Data Source and test successfully.

    Oracle 64 bit Client 12C is installed at F:\app\product\12.1.0\client_2

    Odp.net is installed at F:\app\product\12.1.0\client_1

    Able to do the tnsping successfully and  SQLPLUS connected to the database successfully

    MCPRDEV12C =
        (ADDRESS = (PROTOCOL = TCP)(HOST = scan-server.xyz.org)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = Database.xyz.org)

    TNS_ADMIN Variable is added into environment variables: F:\app\product\12.1.0\client_1\Network\Admin

    Below is Repository services log:

    Microsoft.ReportingServices.Portal.WebHost!processing!3!07/28/2018-13:03:46:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'xxxx'. ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect identifier specified ---> OracleInternal.Network.NetworkException: ORA-12154: TNS:could not resolve the connect identifier specified
       at OracleInternal.Network.AddressResolution..ctor(String TNSAlias, String instanceName)
       at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor)
       at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, String instanceName)
       --- End of inner exception stack trace --

    Any help would be greatly appreciated.

    • Edited by Hareeshkp Saturday, July 28, 2018 9:29 PM
    Saturday, July 28, 2018 9:27 PM