Share via

SSRS 2016, unable to connect the Oracle DB

Abdul 21 Reputation points
2021-04-19T11:53:28.463+00:00

Dear ,SSRS is not working with oracle data base, I made the successfully connection by install the oracle client for 32 and 64 bit and configure the path variable but still i cannot run the report.
Every time i test the connection it ok but when im preview the report it say this badly error .
Which is worst error, I have done many work around but it doest not work.
Pls. check this error and provide the solution as soon as possible.

An error has occurred during report processing. (rsProcessingAborted)
An attempt has been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)

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.
3,061 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments
Accepted answer
  1. Olaf Helper 47,436 Reputation points
    2021-04-20T11:24:17.923+00:00

    Sure, the trial is equal to the Enterprise Edition with all features, that will work, but the trial expires after 180 days.
    If it's only for testing/developing/learning, then you can use the free Developer Edition, it has also all features.

    https://www.microsoft.com/en-us/sql-server/sql-server-2019-comparison

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,436 Reputation points
    2021-04-19T12:57:23.493+00:00

    is not supported in this edition of Reporting Services

    Orcale as data source for SSRS reports works well, there are no known common issues and it's fully supported: Data Sources Supported by Reporting Services (SSRS)

    Regarding the message part above, which Edition are you using?

  2. ZoeHui-MSFT 41,491 Reputation points
    2021-04-20T06:26:04.323+00:00

    Hi @Abdul ,

    Here is a documentation about Configure Oracle data source for SQL Server Reporting Services (SSDT and Report Server).

    https://techcommunity.microsoft.com/t5/sql-server-support/configure-oracle-data-source-for-sql-server-reporting-services/ba-p/319134

    You may refer it for more details to see if there are any steps missing.

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments
  3. Olaf Helper 47,436 Reputation points
    2021-04-20T08:48:35.48+00:00

    Edition : SQL SERVER EXPRESS

    The free Express Edition of SSRS has several limitation, and access remote data sources is one of it; it's not supported in Express, it can only access the local SQL Server database engine of the same instance.

    See SQL Server Reporting Services features supported by editions => Remote and non-SQL data source support => Express: Not supported

Your answer

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