Has anyone successfully connected BCS in SharePoint 2013 to an WCF service?
I did several attempts and always got
Cannot connect to Business Data Connectivity Metadata Store
in the SharePoint Designer when I try to add a connection. I tried various combinations, tested virtually everything. I’ve no idea what I’m doing wrong.
I generally followed MSDN examples for SharePoint 2010 (http://msdn.microsoft.com/en-us/library/office/ff953200%28v=office.14%29.aspx). I took care about BCS permissions, removed references to Microsoft.BusinessData.Runtime (there were only for faults), used anonymous authentication and tried several configurations.
I wonder whether anyone succeeded in doing it. I mean SharePoint 2013, there a lot of examples for 2010. If you did, could you write a few details about your case:
The SharePoint environment you used: SharePoint online, Office 365 Enterprise Preview or SharePoint on-premises (I’ve used Office 365 Enterprise Preview and SharePoint foundation)
The .NET version for the web service; there seem to be compatibility issues between 3.5 and 4.0, I’ve tried both 3.5 and 4.5
The metadata exchange format (WSDL or a mex endpoint; I’ve tried both)
The web service binding (I’ve tried wsHttpBinding as in all examples)
Whether the service was hosted directly as a web application (one of many under port 80) or directly in the web site under a different port (quite surprisingly, there seem to be a difference, in the latter case SharePoint designer apparently downloads some metadata, unfortunately it fails anyway)
Whether you used https or enable this protocol (I haven’t as I used dedicated port for http)
Have you run into any errors during the process, used any special IIS settings, etc.?