Cannot connect to MDS through my Excel Add on (Network Steve Forum)

Cannot connect to MDS through my Excel Add on

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:

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

October 19th, 2014 12:20pm

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

Free Windows Admin Tool Kit Click here and download it now

October 19th, 2014 7:35pm

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

October 20th, 2014 10:37am

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

Free Windows Admin Tool Kit Click here and download it now

October 20th, 2014 2:30pm

EO,

Is this still an issue?

Thanks!

January 20th, 2015 7:54am

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

Proposed as answer by Vincent Chen (X)Microsoft employee, Moderator Tuesday, January 20, 2015 11:34 PM

Free Windows Admin Tool Kit Click here and download it now

January 21st, 2015 2:34am

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

January 22nd, 2015 11:29pm

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:

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

Free Windows Admin Tool Kit Click here and download it now

February 6th, 2015 12:24pm

This topic is archived. No further replies will be accepted.