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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Reporting Server - Data Provider for SAP
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

4 Posts

Posted - 12/02/2012 :  17:32:39  Show Profile  Reply with Quote
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.

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 12/03/2012 :  08:56:21  Show Profile  Reply with Quote
have you tried adding the required references in report project?

SQL Server MVP

Go to Top of Page

Starting Member

1 Posts

Posted - 03/23/2013 :  03:11:07  Show Profile  Reply with Quote

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

Go to Top of Page

Starting Member

4 Posts

Posted - 03/26/2013 :  17:53:21  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000