Master Data Service Add-In connectivity issues RRS feed

  • Question

  • I need help connecting to an instance of master data services on SQL Server 2014.

    Excel 2016 64 bit

    SQL server 2014

    Windows 2008 R2 SP1

    .net framework settings enabled

    http roles enabled

    authentication settings (disable extended protection/ enable windows security/ disable anonymous authentication)

    Connect to web app fine using servername/ mds instance in browser YES

    Connect to db fine using Excel power query YES

    Two errors may occur connect through master data connection property

    1. "This connection failed because the Master Data services web application is older than the Add-In version"

    2. TITLE: Master Data Services Add-in for Excel.  The connection failed because the URL is not valid or the Master Data Services web application version is not supported..  ADDITIONAL INFORMATION: There was no endpoint listening at http://siop/SIOP/mds/service/service.svc/bhb that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. (mscorlib).  The remote server returned an error: (404) Not Found. (System)

    Usually error 1 occurs.  I can then enter an incorrect url and it will repeat the same error message.  I can have two connection strings and test them and receive two different errors.  

    I will provide any information requested to solve this.

    Saturday, July 8, 2017 12:12 AM