Steps I followed to Install SQL Server 2012 Master Data Services (MDS) on my Demo Machine:

Standard

In this blog-post, we’ll see the step by step guide to install SQL Server 2012 Master Data Services (MDS) after you have installed SQL Server 2012 on your machine. I’ve had installed it on my demo machine and you can build one for yourself using the resources listed here: Bird’s Eye view of SharePoint BI Dev Environment Setup process (SQL Server 2012, Sharepoint 2010)

As I mentioned, these are post-sql-server-installation tasks and so I assume you have your BI environment using SQL Server 2012 already up. The official note can be found here: Install Master Data Services

For the purpose of this blog-post, we’ll break the steps into three main sections:

1. Create MDS Database

2. Create Master Data Management Web Application

3. Associate MDS database w/ web Application

So, let’s get started:

Got to: Start > SQL Server 2012 > Master Data Services > Master Data services Configuration

1. Create MDS Database

1a: click on Create Database:

SQL Server 2012 Master Data Services MDS create database

1b: Enter the instance name and credentials:

SQL Server 2012 Master Data Services MDS database credentials

1c: specify the MDS database name and collation:

SQL Server 2012 Master Data Services MDS specify database name

1d: Specify the Administrator Account and review the summary. After it installs successfully – you’ll see a message:

SQL Server 2012 Master Data Services MDS successfully installed

2. Create Master Data management Web Application

2a. Switch to Master Data Services configurations > web configuration > select Create new website

SQL Server 2012 Master Data Services MDS create new website2b. Specify configuration details for the website:

Here’s what I entered:

Website Name: MDS

Port: 81

Host Header: Left it blank

Entered username and password

SQL Server 2012 Master Data Services MDS website configuration

2c. Click on OK and in the web configuration dialog box, click on Create Application

3. Associate MDS database w/ web Application

3a. Under the Associate Application with Database click on Select

SQL server 2012 master data services MDS assoicate database

3b. Select the database that will get associated to the application selected.

* I selected the database that I had created in Step 1

elect the database that will get associated to the application selected.

3c. After successful installation, you’ll see a message:

SQL server 2012 master data services MDS

The web application is then launched in the browser, here you’ll see getting started guide, videos and MDS Samples. Go Explore!

Conclusion

In the blog post, we saw the three post installation tasks for Master Data Services w/ SQL Server 2012.

Again, the official reference is here: Install Master Data Services 

5 thoughts on “Steps I followed to Install SQL Server 2012 Master Data Services (MDS) on my Demo Machine:

What do you think? Leave a comment below.