Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Reporting Server - Data Provider for SAP

Author  Topic 

Shane2077
Starting Member

4 Posts

Posted - 2012-12-02 : 17:32:39
Hi all,

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.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-03 : 08:56:21
have you tried adding the required references in report project?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

su_enm
Starting Member

1 Post

Posted - 2013-03-23 : 03:11:07
hi,

could you find the solution for the error. i have the same problem :(

thanks
Go to Top of Page

Shane2077
Starting Member

4 Posts

Posted - 2013-03-26 : 17:53:21
Hi Su-enm,

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.

Hope this helps
Go to Top of Page
   

- Advertisement -