locked
Excel add-in can't connect to SQL 2014 MDS RRS feed

  • Question

  • I have 2 SQL servers (2012 SP1 & 2014SP1) with MDS. Both are working well on web. I installed the 2014 version Excel add-in, however, it can connect to 2012 instance but failed to connect to 2014 with below error.

    The connection failed because the URL is not valid or the Master Data Manager web application version is not supported.

    ------------------------------
    ADDITIONAL INFORMATION:

    There was no endpoint listening at http://serverxxx/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

    I found similar error in below, but the answer not work for me. Please advise.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4668ec30-f00f-4eaf-8a5e-09d7916905b7/cannot-connect-to-mds-through-my-excel-add-on?forum=sqlmds


    • Edited by md4fun Saturday, August 8, 2015 12:40 AM
    Saturday, August 8, 2015 12:39 AM

Answers

  • After install .Net Framework 4.5 -> WCF Services -> HTTP Activation, issue fixed.
    • Marked as answer by md4fun Saturday, August 8, 2015 9:50 AM
    Saturday, August 8, 2015 9:50 AM

All replies

  • After install .Net Framework 4.5 -> WCF Services -> HTTP Activation, issue fixed.
    • Marked as answer by md4fun Saturday, August 8, 2015 9:50 AM
    Saturday, August 8, 2015 9:50 AM
  • Hi Md4fun,

    Thank you for your sharing which will help to others who have the similar issue.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, August 17, 2015 6:20 AM