associate-a-master-data-services-database-and-web-application.md

title	Associate Database and Web Application
description	In SQL Server, you can associate a Master Data Manager web application with a Master Data Services database to specify the database to use for web operations.
author	meetdeepak
ms.author	dkhare
ms.reviewer	mikeray
ms.date	03/05/2026
ms.service	sql
ms.subservice	master-data-services
ms.topic	how-to
ms.custom	build-2025

Associate a Master Data Services Database and Web Application

[!INCLUDE SQL Server Windows Only - ASDBMI]

[!INCLUDE support-notice]

Associate your [!INCLUDEssMDSmdm] web application with a [!INCLUDEssMDSshort] database to specify the database to use for web operations.

Prerequisites

• [!INCLUDEssMDScfgmgr] must be installed on the local computer. For more information, see Install Master Data Services.

• A local [!INCLUDEssMDSmdm] web application must exist. For more information, see Create a Master Data Manager Web Application (Master Data Services).

• Either a local or remote [!INCLUDEssMDSshort] database must exist. For more information, see Create a Master Data Services Database.

To associate a Master Data Services database and web application

1. Open [!INCLUDEssMDScfgmgr].

2. In the left pane, click Web Configuration.

3. On the Web Configuration page, under Web application, from the Website list, select the website that contains your [!INCLUDEssMDSmdm] web application.

4. In the Web application box, select the web application that hosts [!INCLUDEssMDSmdm].

5. Under Associate Application with Database, click Select. The Connect to Database dialog box opens.

6. Specify connection information for the instance of [!INCLUDEssNoVersion] that hosts the [!INCLUDEssMDSshort] database, and click Connect.

7. From the Master Data Services database list, select the database you want to associate the web application with and then click OK.

8. Under Associate Application with Database, verify that the instance and database information are correct, and then click Apply.

Next Steps

• Programmatic access to [!INCLUDEssMDSshort] web services is automatically enabled when the web application is created. To let developers access the service metadata to easily generate proxy classes for programmatic access, enable metadata publishing. For more information, see Create Master Data Manager Web Service Proxy Classes.

• Add users and groups to [!INCLUDEssMDSmdm]. If no users or groups have been granted access to [!INCLUDEssMDSmdm], you must open [!INCLUDEssMDSmdm] using the [!INCLUDEssMDSshort] system administrator credentials. For more information, see Administrators (Master Data Services) and Users and Groups (Master Data Services).

See Also

Install Master Data Services
Web Configuration Page (Master Data Services Configuration Manager)