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

title	Associate a Master Data Services Database and Web Application | Microsoft Docs
ms.custom
ms.date	03/17/2017
ms.prod	sql-non-specified
ms.prod_service	mds
ms.service
ms.component	install-windows
ms.reviewer
ms.suite	sql
ms.technology	setup-install
ms.tgt_pltfrm
ms.topic	article
ms.assetid	ccb25672-f71d-4135-b548-f50eb45d8fa5
caps.latest.revision	9
author	smartysanthosh
ms.author	nagavo
manager	craigg
ms.workload	Inactive

Associate a Master Data Services Database and Web Application

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)