Time for action – configuring MDS

In this example, you will learn how to configure MDS. The configuration will allow you to create the database for MDS and also set up the WebUI of MDS. Please note that when you install MDS through the SQL Server setup media, the database and web application will not configure, so you need to configure them manually the first time.

  1. After installing SQL Server 2012, open Master Data Services Configuration Manager from the Start menu under Microsoft SQL Server 2012.
  2. Go to the Database Configuration tab and click on Create Database.
  3. Follow the wizard steps to create a database named MDS under the local SQL Server instance.
  4. Go to Web Configuration and choose a default website from the drop-down list.
  5. Create an application ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial