Error in /Service/Service.svc/bhb when open MDS Explorer

All replies

• 

  

  0

  Sign in to vote

  Hi Nick,

  Please refer to the following article to see if this help to solve this issue:
  Error message when you try to visit a Web page that is hosted on IIS 7.0: "HTTP Error 401.2 - Unauthorized": http://support.microsoft.com/kb/942043

  For more information, please see the following article:
  http://blog.hoegaerden.be/2010/02/14/iis-7-5-and-windows-authentication/

  Best Regards,

  ---

  Elvis Long
  TechNet Community Support

  

  • Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, January 20, 2015 5:03 AM

  Tuesday, July 23, 2013 2:43 AM
• 

  

  0

  Sign in to vote

  Hi! Elvis,

  Thanks for your response , I try those settings but still not work. The current IIS setting is as below

  Authentication :
  (a) MDS Website : Enable Windows Authentication. Disable Anonymous Authentication.
  Under Windows Authentication > Advanced Settings > set Extended Protection = Accept or Required
  (b) Service Folder : Enable Windows Authentication. Enable Anonymous Authentication.

   

  I trace by Fiddler and Green arrows point out the bad request when I access Explorer.

  Detail error is  https://dl.dropboxusercontent.com/u/12915406/MDS/fiddler-log.html
  HTTP Error 401.2 - Unauthorized is still the same even apply the suggestions from the links you provided.
  

  
  

  I wonder what \Service.svc\bhb is , find bhb in Web.config and set some Authentication to None to test if I can bypass it.

  Now the Fiddler has different error.

  a:DestinationUnreachable
  The message with To 'http://mdsdev.tw.companynet.org:88/Service/Service.svc/bhb' cannot be processed at the receiver, due to an AddressFilter mismatch at the EndpointDispatcher. Check that the sender and receiver's EndpointAddresses agree.

  
  

  This link has similar problem but I have no idea where I can apply his workaround in my environment.

  http://social.msdn.microsoft.com/Forums/vstudio/en-US/b5ae495b-f5fb-4eed-ae21-2b2280d4fec3/address-filter-mismatch-wcf-addressing

  Append my Web.confg and applicationHost.config snippet  for your reference.
  Thank you so much!
  
  Web.Config

  <system.serviceModel>
      <behaviors>
        <serviceBehaviors>
          <behavior name="mdsWsHttpBehavior">
            <serviceMetadata httpGetEnabled="true" httpsGetEnabled="false" /> 
            <serviceDebug includeExceptionDetailInFaults="false" />
            <serviceThrottling maxConcurrentSessions="400" />
            <dataContractSerializer maxItemsInObjectGraph="999999999" />
  		 </behavior>
        </serviceBehaviors>
  	</behaviors>
      <bindings>
        <wsHttpBinding>
          <binding name="mdsWsHttpBinding" maxBufferPoolSize="2147483647" maxReceivedMessageSize="2147483647">
            <readerQuotas maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxDepth="2147483647" maxNameTableCharCount="2147483647" maxStringContentLength="2147483647" />
            <security mode="Message">
              <message clientCredentialType="Windows" />
  			<transport clientCredentialType="Windows">
  						  <extendedProtectionPolicy policyEnforcement="WhenSupported" />
  			</transport>
            </security>
          </binding>
        </wsHttpBinding>
        <basicHttpBinding>
          <binding name="mdsBasicHttpBinding" maxBufferPoolSize="2147483647" maxReceivedMessageSize="2147483647">
            <readerQuotas maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxDepth="2147483647" maxNameTableCharCount="2147483647" maxStringContentLength="2147483647" />
      	  <security mode="None">
              <transport clientCredentialType="None" />
  	      </security>
          </binding>
        </basicHttpBinding>
      </bindings>
      <services>
        <service behaviorConfiguration="mdsWsHttpBehavior" name="Microsoft.MasterDataServices.Services.Service">
  	    <endpoint binding="wsHttpBinding" bindingConfiguration="mdsWsHttpBinding" bindingNamespace="
  		http://schemas.microsoft.com/sqlserver/masterdataservices/2009/09" contract="Microsoft.MasterDataServices.Services.ServiceContracts.IService" />
          <!--Silverlight doesn't support wsHttpBinding -->
          <endpoint address="bhb" binding="basicHttpBinding" bindingConfiguration="mdsBasicHttpBinding" bindingNamespace="http://schemas.microsoft.com/sqlserver/masterdataservices/2009/09" contract="Microsoft.MasterDataServices.Services.ServiceContracts.IService" />
        </service>
      </services>
    </system.serviceModel>

  applicationHost.config

  <location path="Default Web Site">
          <system.webServer>
              <security>
                  <authentication>
  					<basicAuthentication enabled="false" />
                      <windowsAuthentication enabled="true" useKernelMode="true">
                          <extendedProtection tokenChecking="Allow" />
                      </windowsAuthentication>
  					<anonymousAuthentication enabled="true" />
                  </authentication>
              </security>
          </system.webServer>
      </location>
      <location path="MDS">
          <system.webServer>
              <security>
                  <authentication>
  					<basicAuthentication enabled="true" />
                      <windowsAuthentication enabled="true" useKernelMode="true">
                          <extendedProtection tokenChecking="Allow" />
                      </windowsAuthentication>
                      <anonymousAuthentication enabled="false" />
                  </authentication>
              </security>
          </system.webServer>
      </location>
      <location path="MDS/Service">
          <system.webServer>
              <security>
                  <authentication>
  					<basicAuthentication enabled="true" />
                      <anonymousAuthentication enabled="true" userName="" />
  					<!--anonymousAuthentication enabled="true" userName="" /-->
                      <windowsAuthentication enabled="true" />
                  </authentication>
              </security>
          </system.webServer>
      </location>

  
  

  Tuesday, July 23, 2013 8:10 AM
• 

  

  5

  Sign in to vote

  Nick,

  Not sure if you have solved the issue, but I had similar issues when playing around with MDS in my lab.

  I had it installed on Windows Server 2012 R2. The application pool my application was running was .Net 4, so I also had to install the HTTP Activation and TCP Activation features under 4.5 Framework Features -> WCF Features (not sure if you need the TCP Activation, but I installed it just in case).

  After doing so, MDS Explorer works without errors.

  • Marked as answer by Ed Price - MSFTMicrosoft employee Tuesday, January 20, 2015 5:04 AM

  Thursday, November 28, 2013 1:23 PM
• 

  

  1

  Sign in to vote

  Thanks indigocy, that fixed an issue I had with connecting to SQL Server 2014 CTP2 MDS from Excel too.

  Friday, February 21, 2014 6:16 AM
• 

  

  0

  Sign in to vote

  hi all;

  in my case this are the modifications that i have done:

  add to web.config : 
  <system.serviceModel>
      <serviceHostingEnvironment multipleSiteBindingsEnabled="true" >
      </serviceHostingEnvironment>
    </system.serviceModel>

   ref (http://www.dotnetfunda.com/forums/show/4546/this-collection-already-contains-an-address-with-scheme-http-there-can)

  modify auyhentification:

  Open the Internet Information Services (IIS) Manager 
  Expand: MDS Sites  
  Open Authentication 
  Select Windows Authentication 
  Select Advanced Settings... (on the right hand side) 
  Set Extended Protection to Off 
  Save the settings 
  Run the command: iisreset /noforce

  (ref:http://www.gfi.com/support/products/Error-The-ExtendedProtectionPolicy-PolicyEnforcement-values-do-not-match-IIS-has-a-value-of-WhenSupported-while-the-WCF-Transport-has-a-value-of-Never-when-a-client-attempts-to-connect-to-the-serve)

  see also the following link they are usefull:
  
  https://blogs.msdn.microsoft.com/jason_howell/2011/08/04/mds-services-svc-web-service-gives-http-error-404-3-not-found-after-i-just-installed-it-successfully/
  http://social.technet.microsoft.com/wiki/contents/articles/4520.troubleshooting-the-master-data-services-add-in-for-excel.aspx

  
  

  • Edited by karimb85 Tuesday, April 26, 2016 9:54 AM

  Tuesday, April 26, 2016 9:52 AM
• 

  

  0

  Sign in to vote

  FYI, I fixed this issue by changing the security mode from Message and TransportCredentialOnly to Transport into the <bindings> paragraph into web.config.

  By hoping this will help someone lost as I were :p

  
  

  • Edited by Fred_DBA Wednesday, February 19, 2020 8:46 AM

  Wednesday, February 19, 2020 8:44 AM
• 

  

  0

  Sign in to vote

  This is just a memory issue, free your ram, problem goes away.

  Monday, June 8, 2020 9:03 AM