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
Comments
Master Data Services Web Services API Error — No Comments
HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>