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 is SQL Server MVP and a independent consultant with the title of Business Intelligence/Data Warehouse/Master Data Management Architect and Developer, specializing in the Microsoft SQL Server BI stack.
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>