Master Data Services Add-in for Excel Issue RRS feed

  • General discussion

  • I am trying to configure MDS in the Production server. I am running into isssues.

    (I was able to do the whole process successfuly in my local system - Versions are same in the local and server - Only difference is local machine is windows 7 server is Windows 2008 R2)

    I have installed SQL server 2012 Enterprise Version SP1. I am able to browse the MDS URL. User has got full permissions. When I try to access the MDS via Excel I get the below error.

    Can any one help me please I have spent days on this withou any joy.

    Error message

    TITLE: Master Data Services Add-in for Excel

    An error occurred while receiving the HTTP response to http://MYIPADDRESS/mds/service/service.svc/bhb. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details.


    The underlying connection was closed: An unexpected error occurred on a receive. (System)


    Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)


    An existing connection was forcibly closed by the remote host (System)




    Thursday, June 12, 2014 4:50 PM

All replies

  • Hello,

    We are having the same problem.

    How did you fix the problem?


    Thursday, May 5, 2016 6:59 AM
  • Are you able to connect to MDS service via Web URL from the same client? Do you provide the exact same URL to Excel Addin?

    If yes, try to look at the log in Master Data Service, and it might provide a clue.


    Friday, May 6, 2016 11:38 PM
  • Hello,

    We are also having the same problem. What was the fix?



    Tuesday, May 24, 2016 1:21 AM
  • Hi there,

    Please share the solution/fix. We are experiencing the same issue.


    Monday, October 3, 2016 5:36 PM
  • I'm also facing the same problem, has anyone found out how to fix this?

    I've tried reinstalling the Excel plugin and removing/adding the connection from Excel. With IE I can connect to same MDS url.

    - Juha S

    Tuesday, November 8, 2016 8:37 PM