Master Data Services Web Services API Error

In Master Data Services (MDS), I received an error when using C# code in the script task in SSIS 2012 to call the MDS web services API:

To fix this, I had to edit the web.config in C:\Program Files\Microsoft SQL Server\110\Master Data Services\WebApplication:

Under ” <behavior name=”mdsWsHttpBehavior”>”

Change

<serviceMetadata httpGetEnabled=”false” httpsGetEnabled=”false”/>

To

<serviceMetadata httpGetEnabled=”true” httpsGetEnabled=”false”/>

Under “<basicHttpBinding>”

Change

<security mode=”TransportCredentialOnly”>
<transport clientCredentialType=”Windows”/>
</security>

To

<security mode=”TransportCredentialOnly”>
<transport clientCredentialType=”None”/>
</security>

More info:

Getting Started with the Web Services API in SQL Server 2008 R2 Master Data Services

Web Configuration Reference (Master Data Services)

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in MDS/MDM, SQLServerPedia Syndication, SSIS. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>