Search code examples
sql-serverreporting-services

Why SQL Server Reporting Services only showing MS SQL Server as only available Data Source?


When I try to create a new data source in SSRS web browser, the only available connection type avaiable is MS SQL Server. Why is it not showing other sources. Although I've already installed Oracle and it's required drivers.

What could be the issue ?

Screenshot of Data Sources available


Solution

  • So the answer to the question is that SQL Server Reporting Services is no longer compatible with newer Windows Server Machines hence all the issues.

    So, I installed Power BI Reporting Services (PBIRS) instead of SSRS. and everything works fine now.