MDS Excel Add-in: There was no endpoint listening at https://<<servername>>/MDS/service/service.svc/bhb that could accept the message
Category: sql server masterdata
Guillaume Fraiture on Thu, 27 Oct 2016 13:22:33
When trying to connect to MDS via the Excel Add-in, I get the following error:
Even if the webservice seems to be running fine:
The URL specified in the error message is pretty strange... (adding service.svc/bhb)
Would you have any idea on how to solve this ?
davidbaxterbrowne on Thu, 27 Oct 2016 13:35:34
>The URL specified in the error message is pretty strange... (adding service.svc/bhb)
That's because MDS has two _separate_ web service endpoints. They use the same WSDL contract, but different WCF bindings. The endpoint at service.svc uses the WsHttpBinding, and the endpoint at service.svc/bhb uses the BasicHttpBinding. The Excel Add-In uses the BasicHttpBinding endpoint at .../service.svc/bhb.