Associate a Master Data Services Database and Web Application

Applies to: SQL Server - Windows only Azure SQL Managed Instance

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.

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.

Programmatic access to Master Data Services 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 Master Data Manager. If no users or groups have been granted access to Master Data Manager, you must open Master Data Manager using the Master Data Services system administrator credentials. For more information, see Administrators (Master Data Services) and Users and Groups (Master Data Services).