Cannot connect to MDS through my Excel Add on

Article
10/19/2014

Question

_{Sunday, October 19, 2014 9:20 AM}

Installed MDS for SQL 2012. Created a website as a default website. I can navigate to the website.

But I cannot access MDS using the Excel add-on. Been struggling with this for hours now and very little out there on the issue.

When I connect I use all conceivable permutations of the URL...

http://server/mds

http://localhost/mds

htto://server:80/mds

http://localhost:80/mds

I get the following error

TITLE: Master Data Services Add-in for Excel

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://server/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. (Microsoft.MasterDataServices.AsyncEssentials)

The remote server returned an error: (404) Not Found. (System)

BUTTONS:

'If this was helpful, please mark and an answer or as being helpful'

All replies (7)

_{Tuesday, January 20, 2015 11:34 PM ✅Answered | 1 vote}

From your trace log

The server address looks like http://etienne:50000/

But, from your original post it is more likely http://localhost/mds

Can you double check if the connections is set correctly in Excel?

You also clean up the user setting, if you are not sure why it is connecting to http://etienne:50000/

C:\Users\UserName}\AppData\Local\Microsoft\Microsoft SQL Server\version}\MasterDataServices\excelusersettings.config

_{Friday, February 6, 2015 5:19 PM ✅Answered | 1 vote}

I was getting a similar error as above. Did few changes in the client configuraiton and it worked.

From run menu executed => Cliconfg and ensured that TCP/IP , Named pipes are selected.Enable shared memory protocol checked.

In SSCM under SQL Server Network Configuration Enabled all the 3 protocols.

Restarted the SQL Server instance.

After that i was able to make a successfull connection test in EXCEL.

Regards

Madhana

Error Details:

===========

TITLE: Master Data Services Add-in for Excel

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://lab1-pc:333/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. (Microsoft.MasterDataServices.AsyncEssentials)

The remote server returned an error: (404) Not Found. (System)

BUTTONS:

MCTS/MCITP (SQL Server 2005, 2008, 2005 BI)

_{Sunday, October 19, 2014 4:35 PM | 1 vote}

Here are the steps I would go through to troubleshoot.

1) Connect to the MDS web site and then use that address. (that proved the URL is valid) like: http://server/mds

2) Copy that address into the Add New Connection screen. (if this does not work, follow the below)

3) Start SQL Profiler and filter to the MDS database and make the connection to MDS from the web site (works and SQL Profiler setup correctly)

4) Make a connection to MDS from Excel and see what SQL Profiler says.

This sounds like a permissions issue. Are you on the same machine as MDS?

Hope this Helps

Reeves

Denver, CO

_{Monday, October 20, 2014 7:37 AM | 1 vote}

Hi Reeves

(1) Tried, all permutations, I even deleted the web app and created a new one from scratch on port 81 (non default website)

(2) Tried, all permutations

(3) SQL profiler picks up traces and I can sign in correctly

(4) SQL profiler picks up nothing when trying to connect through Excel

On the same machine as MDS, windows 8 pro, Excel 2013

'If this was helpful, please mark and an answer or as being helpful'

_{Monday, October 20, 2014 11:30 AM | 1 vote}

Hi,

In addition to the message above. I enabled the logging in the Master Data tab in Excel (see Enabling Diagnostic Logging for advanced troubleshooting here http://social.technet.microsoft.com/wiki/contents/articles/4520.troubleshooting-the-master-data-services-add-in-for-excel.aspx). The logging results added here. Still none the wiser.

But note that I recently upgraded by OS key from Windows 8 (basic) to Windows 8 Pro. So not sure if that has created a false positive (I.e. an MDS site working, whilst it actually does not).

2014-10-20T21:37:49.425        5488 EXCEL.EXE            EXCEL.EXE                                Generic          EventType: Error, Message: MDS Excel plugin started successfully. Assembly version: 11.0.0.0, File version: 11.0.3393.0 ((SQL11_SP1_QFE-CU).131025-1850 )
2014-10-20T21:47:42.847        4820 EXCEL.EXE            EXCEL.EXE                                Generic          EventType: Error, Message: Async executer exception System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://localhost:50000/service.svc/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. > System.Net.WebException: The remote server returned an error: (404) Not Found.
   at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
   End of inner exception stack trace

Server stack trace:
   at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.SendAsyncResult.End(SendAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)
   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeEndService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Microsoft.MasterDataServices.ExcelAddInCore.MDSService.IService.EndMetadataGet(IAsyncResult result)
   at Microsoft.MasterDataServices.ExcelAddInCore.Operations.SequenceOperationExecuter.TestConnection()
   at Microsoft.MasterDataServices.ExcelAddInCore.Operations.SequenceOperationExecuter.<Body>d__0.MoveNext()
   at Microsoft.MasterDataServices.AsyncEssentials.AsyncExecuter`1.Advance()
2014-10-20T21:47:42.863        4820 EXCEL.EXE            EXCEL.EXE                                Generic          EventType: Error, Message: Received EndpointNotFoundException. Showing custom error that it might be wrongly typed URL or old server. Exception: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://localhost:50000/service.svc/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. > System.Net.WebException: The remote server returned an error: (404) Not Found.
   at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
   End of inner exception stack trace

Exception rethrown at [0]:
   at Microsoft.MasterDataServices.AsyncEssentials.AsyncResultBase.EndInvoke()
   at Microsoft.MasterDataServices.AsyncEssentials.AsyncResult`1.EndInvoke()
   at Microsoft.MasterDataServices.ExcelAddInCore.ConnectionManager.<>c__DisplayClasse.<TestConnectionAsync>b__c(IAsyncResult ar)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
2014-10-20T21:47:43.191        5488 EXCEL.EXE            EXCEL.EXE                                Generic          EventType: Error, Message: ExceptionMessageBoxShown@The connection failed because the URL is not valid or the Master Data Manager web application version is not supported.
2014-10-20T21:50:12.172       11560 EXCEL.EXE            EXCEL.EXE                                Generic          EventType: Error, Message: Async executer exception System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://localhost:50000/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. > System.Net.WebException: The remote server returned an error: (404) Not Found.
   at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
   End of inner exception stack trace

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Microsoft.MasterDataServices.ExcelAddInCore.MDSService.IService.EndMetadataGet(IAsyncResult result)
   at Microsoft.MasterDataServices.ExcelAddInCore.Operations.SequenceOperationExecuter.TestConnection()
   at Microsoft.MasterDataServices.ExcelAddInCore.Operations.SequenceOperationExecuter.<Body>d__0.MoveNext()
   at Microsoft.MasterDataServices.AsyncEssentials.AsyncExecuter`1.Advance()
2014-10-20T21:50:12.172       11560 EXCEL.EXE            EXCEL.EXE                                Generic          EventType: Error, Message: Received EndpointNotFoundException. Showing custom error that it might be wrongly typed URL or old server. Exception: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://localhost:50000/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. > System.Net.WebException: The remote server returned an error: (404) Not Found.
   at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
   End of inner exception stack trace

Exception rethrown at [0]:
   at Microsoft.MasterDataServices.AsyncEssentials.AsyncResultBase.EndInvoke()
   at Microsoft.MasterDataServices.AsyncEssentials.AsyncResult`1.EndInvoke()
   at Microsoft.MasterDataServices.ExcelAddInCore.ConnectionManager.<>c__DisplayClasse.<TestConnectionAsync>b__c(IAsyncResult ar)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
2014-10-20T21:50:12.396        5488 EXCEL.EXE            EXCEL.EXE                                Generic          EventType: Error, Message: ExceptionMessageBoxShown@The connection failed because the URL is not valid or the Master Data Manager web application version is not supported.
2014-10-20T21:53:32.346        7444 EXCEL.EXE            EXCEL.EXE                                Generic          EventType: Error, Message: Async executer exception System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://etienne:50000/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. > System.Net.WebException: The remote server returned an error: (404) Not Found.
   at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
   End of inner exception stack trace

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Microsoft.MasterDataServices.ExcelAddInCore.MDSService.IService.EndMetadataGet(IAsyncResult result)
   at Microsoft.MasterDataServices.ExcelAddInCore.Operations.SequenceOperationExecuter.TestConnection()
   at Microsoft.MasterDataServices.ExcelAddInCore.Operations.SequenceOperationExecuter.<Body>d__0.MoveNext()
   at Microsoft.MasterDataServices.AsyncEssentials.AsyncExecuter`1.Advance()
2014-10-20T21:53:32.346        7444 EXCEL.EXE            EXCEL.EXE                                Generic          EventType: Error, Message: Received EndpointNotFoundException. Showing custom error that it might be wrongly typed URL or old server. Exception: System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://etienne:50000/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. > System.Net.WebException: The remote server returned an error: (404) Not Found.
   at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
   at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelAsyncRequest.CompleteGetResponse(IAsyncResult result)
   End of inner exception stack trace

'If this was helpful, please mark and an answer or as being helpful'

_{Tuesday, January 20, 2015 4:54 AM}

EO,

Is this still an issue?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

_{Thursday, January 22, 2015 8:29 PM | 1 vote}

I have the exact same problem, with the same configuration:

SQL Server 2012 SP1 installed on my machine (Windows 8 Professional), every MDS companents installed on my local machine.

Exactly same error message (the only difference is the server name). MDS works when I access it from my browser.

I would like to know if you find any solution?

Paul

Share via

Cannot connect to MDS through my Excel Add on

Question

All replies (7)

Additional resources