Reports not running on SSRS/SQL 2022 on Windows Server 2022

Question

Hi All, Previously we were running on older version of SQL, SSRS and Windows server. When we published the reports to that server everything works as expected. Recently we started using new server [Windows 2022] with ew installation of SQL 2022 & SSRS 2022. When we published the reported to new environment, it's giving us below error. We also installed the Oracle 21c drivers [admin version]. Error:
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. Hide error details 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 Any help or information will help us. Thank you in advance.

Answer 1

Hi @JAGGU SRU,

Seems like a 32bit vs 64bit issue, so you need to install two version to test and you can refer to this link: https://stackoverflow.com/questions/39776069/ssdt-in-visual-studio-2015-oracle-connection-issue.
For more details, you could refer to https://learn.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-2017 and https://learn.microsoft.com/en-gb/archive/blogs/dataaccesstechnologies/configure-oracle-data-source-for-sql-server-reporting-services-ssdt-and-report-server

Regards，

Zoe Hui

---

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