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.
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
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 |
|
|
|
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 |
|
|
|
|
|
|
Reporting Server - Data Provider for SAP