Skip to content

Latest commit

 

History

History
70 lines (42 loc) · 3.57 KB

File metadata and controls

70 lines (42 loc) · 3.57 KB
title Secure a Master Data Manager Web Application
description In SQL Server, you can secure the Master Data Manager web application with HTTPS. You must be an administrator and MDS must be installed on the web server.
author CordeliaGrey
ms.author jiwang6
ms.date 03/01/2017
ms.service sql
ms.subservice master-data-services
ms.topic how-to
ms.custom
build-2025

Secure a Master Data Manager Web Application

[!INCLUDE SQL Server Windows Only - ASDBMI]

[!INCLUDE support-notice]

You can secure the [!INCLUDEssMDSmdm] web application with HTTPS.

Note

The [!INCLUDEssMDSmdm] web application can use either HTTP or HTTPS, but not both.

Prerequisites

To perform the procedure:

To secure the Master Data Manager web application with HTTPS

  1. After you have confirmed that the [!INCLUDEssMDSmdm] web application is configured correctly with HTTP, create a certificate in IIS. For more information, see Configuring Server Certificates in IIS 7.

  2. In the Connections pane, under Sites, click the site that hosts the [!INCLUDEssMDSmdm] web application.

  3. In the Actions pane, click Bindings.

  4. Click Add.

  5. From the list, select https.

  6. Select the TLS/SSL certificate.

  7. Click OK.

  8. Optional. To remove HTTP so that users can access the site with HTTPS only, from the list, click the row with http. Click Remove and on the confirmation dialog box, click Yes.

    [!IMPORTANT]
    You must change basicHttp and wsHttpBinding configurations after removing HTTP.

  9. To close the Site Bindings dialog box, click Close.

  10. Now open the web.config file from drive:\Program Files\Microsoft SQL Server\130\Master Data Services\WebApplication.

  11. Find the string <security mode="Message"> and change it to <security mode="Transport">.

  12. Change <serviceMetadata httpGetEnable="true" httpsGetEnabled="false"> to <serviceMetadata httpGetEnable="false" httpsGetEnabled="true"> to prevent issues that may appear in the Silverlight client.

  13. Save and close the file. If you get an error, it could be because you have UAC enabled. Users should now be able to use HTTPS to access the site.

See Also

Create a Master Data Manager Web Application (Master Data Services)