locked
SSRS 2019 and Oracle DB with Oracle Client 12c RRS feed

  • Question

  • Hello GM.

    We just installed SSRS 2019 on a new Windows 2016 server (Amazon ec2, our app server). We are now using Oracle Client 12c on the app server to create a data source. We are able to connect to the Oracle db fine (validated via SQLPlus), but not able to create a data source.

    We also installed the 64 bit drivers per https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15.

    we are getting the below error message.

    Error in the Report Manager

    Couldn't connect

    The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

    A connection cannot be made. Ensure that the server is running.

     

    Error in the SSRS Trace Log file

     

    processing!ReportServer_0-7!2f58!03/12/2020-15:24:14:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source ''. ---> Microsoft.ReportingServices.XmlaClient.AdomdConnectionException: A connection cannot be made. Ensure that the server is running. ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.237.242.149:2383

       at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)

       at Microsoft.ReportingServices.XmlaClient.XmlaClient.GetTcpClientByAddress(String hostName, Int32 port)

       at Microsoft.ReportingServices.XmlaClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

       --- End of inner exception stack trace ---

       at Microsoft.ReportingServices.XmlaClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

       at Microsoft.ReportingServices.XmlaClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)

       at Microsoft.ReportingServices.XmlaClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)

       at Microsoft.ReportingServices.XmlaClient.AdomdConnection.XmlaClientProvider.Microsoft.ReportingServices.XmlaClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()

       at Microsoft.ReportingServices.XmlaClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)

       at Microsoft.ReportingServices.XmlaClient.AdomdConnection.Open()

       at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.<>c__DisplayClass5_0.<OpenDataSourceExtensionConnection>b__0()

       at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.HandleImpersonation(IProcessingDataSource dataSource, DataSourceInfo dataSourceInfo, String datasetName, IDbConnection connection, Action afterImpersonationAction)

       at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName)

    Friday, March 13, 2020 12:22 PM

Answers

  • Glad it is resolved, you could mark the solution as answer. It could help other user who had similar issue. :)

    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by LavaBo Monday, April 6, 2020 2:55 PM
    Wednesday, March 25, 2020 1:35 AM

All replies

  • Hi LavaBo,

    From the error message, it only suggest that we need to double check the datasource credential and connection string.

    Could you establish connection and make datasource with other database ?

    Make sure that you've followed correct each step in the link Oracle Connection Type.

    Here is some reference that I thought might help:Common connection string examples

    BTW, seems you only need to use SSRS in this scene but not SQL Server, have you got sufficient licences for production test?

    Regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, March 16, 2020 2:42 AM
  • Thanks much Lucas. 

    The credentials themselves are fine since the same set of credentials work in other servers; as well as via SQLPlus on this server.

    After further analysis, we realized that we also need ODP and ODAC. We are working on that now to get the correct version installed and then try the Oracle connection type when creating a Data Source.

    Tuesday, March 17, 2020 11:40 AM
  • Hi LavaBo,

    Have you resolved the issue? We are happy to know some feedback to see if we could help. :)

    Regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, March 20, 2020 1:42 AM
  • Thanks again Lucas. We need 18.0 Oracle Client to work with SSRS 2019. Once we installed the 64 bit version of that, we are good.
    Friday, March 20, 2020 9:32 PM
  • Glad it is resolved, you could mark the solution as answer. It could help other user who had similar issue. :)

    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by LavaBo Monday, April 6, 2020 2:55 PM
    Wednesday, March 25, 2020 1:35 AM