none
Master Data Services Add-in for Excel Issue

    Allgemeine Diskussion

  • 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.

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

    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)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------


    Bn

    Donnerstag, 12. Juni 2014 16:50

Alle Antworten

  • Hello,

    We are having the same problem.

    How did you fix the problem?

    Thanks.

    Donnerstag, 5. Mai 2016 06:59
  • 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.

    Thanks

    Freitag, 6. Mai 2016 23:38
  • Hello,

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

    Thanks,

    Tony.

    Dienstag, 24. Mai 2016 01:21
  • Hi there,

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

    Thanks..

    Montag, 3. Oktober 2016 17:36
  • 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.

    BR
    - Juha S

    Dienstag, 8. November 2016 20:37