We have installed the Data Provider for SAP adapter (BizTalk) on our Reporting Server. The extension name "Data Provider for SAP" exists in rsreportserver.config. However when trying to create a dataset in Report Builder on a named instance on the Report Server the error "The selected data extension Data Provider for SAP is not installed or cannot be loaded". The Biztalk adapter has been uninstalled and reinstalled with the same error message being displayed.
If anyone could give a suggestion of where to start looking in the Report Server configuration to get this working it would be appreciated.
No solution could be found. The Data Provider for SAP is installed on the Reporting Server (rsconfig), however when executing Report Builder, Report Builder runs from the client side with the config file loaded from resources of MSReportBuilder.exe. Those resources are hard coded and cannot be modified to add in the Data Provider for SAP. What I am now doing is creating SAP data sources and datasets in BIDS and deploying the datasets to the Report Server where the reports can then be built using Report Builder and then published on the Reporting Server.