Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server on Windows
Azure SQL Managed Instance
Important
Master Data Services (MDS) is removed in SQL Server 2025 (17.x). We continue to support MDS in SQL Server 2022 (16.x) and earlier versions.
Associate your Master Data Manager web application with a Master Data Services database to specify the database to use for web operations.
Prerequisites
Master Data Services Configuration Manager must be installed on the local computer. For more information, see Install Master Data Services.
A local Master Data Manager web application must exist. For more information, see Create a Master Data Manager Web Application (Master Data Services).
Either a local or remote Master Data Services database must exist. For more information, see Create a Master Data Services Database.
To associate a Master Data Services database and web application
Open Master Data Services Configuration Manager.
In the left pane, click Web Configuration.
On the Web Configuration page, under Web application, from the Website list, select the website that contains your Master Data Manager web application.
In the Web application box, select the web application that hosts Master Data Manager.
Under Associate Application with Database, click Select. The Connect to Database dialog box opens.
Specify connection information for the instance of SQL Server that hosts the Master Data Services database, and click Connect.
From the Master Data Services database list, select the database you want to associate the web application with and then click OK.
Under Associate Application with Database, verify that the instance and database information are correct, and then click Apply.