How to enable Master Data Services (MDS) in SQL Server 2008 R2

Enabling Master Data Services (MDS) in SQL Server 2008 R2 is easy, but it isn’t a part of the regular installation process so I thought I’d show you how. It is in fact veeery simple! There are however some prerequisites:

  • Master Data Services is only available in 64-bit environments
  • You need to have the .NET Framework 3.5 SP1 installed (this is installed with SQL 2008 R2)
  • You need to enable the IIS-role on the server in order to run the Master Data Manager

If you open up the SQL 2008 R2  installation media and browse the files on the DVD/ISO you will find a  folder there called Master Data Services. You will have to traverse through a few subfolders but the only content once you get to the bottom is an .msi-file called “MasterDataServices.msi”. There is not a whole lot of configuration to be done in the installer, so just run it like any other .msi and wait until it finishes.

Once the installer is finished the Master Data Services Configuration Manager should open itself up automatically. If it doesn’t you’ll find it on the Start menu under SQL Server 2008 R2 -> Master Data Services -> Configuration Manager. It should look like this:

Create an MDS database

The next thing you need to do is to create the Master Data Services database. Click “Databases” and then “Crate database” and it will open up a wizard for you that will take you through the create process. After af ew clicks it will ask you to authenticate to the server where the MDS database will be created, and after that you are asked to specify a database name. I usually like to call it “MDS” for simplicity:

Then you are asked to specify a service account. This is an account that the Master Data Services website (Master Data Manager) will use to authenticate with the MDS database. It will have to be a Windows account, either a local one or preferably a domain account.

The next page in the wizard tells you to specify the administrator account. And this is very important: The administrator account CAN NOT be changed at a later time!

And that’s it for the database! When the create database wizard is finished you can browse the different settings

Configuring the Master Data Manager website

Once the database has been created it’s time to set up the Master Data Manager Website. Go to Web Configuration in the Configuration Manager and click the “Create Site“-button…it will start a wizard that will create all the stuff you need:

The create site pop-up should look something like this:

You might get an error if you try to set the new site up to run on port 80 because the Default Web Site already runs on this port. Specify a host header, change the port number or remove the default web site to resolve this issue.

Connect the Master Data Manager website with the MDS database

When the new MDS website has been created you have to connect it to the MDS database in order for it to work properly. Click the Select… button in the database section of the window to open up the database connection. Specify the connection properties and choose the newly created MDS database, and then click OK. It should look something like this:

Once you have done this you are done! The only thing left is to decide whether you would like to expose Master Data Services as a web service and if you are in a master data management project you’ll most likely want to do that. So check the check box:

Click Apply and all the settings you have created are saved and if all goes well (crossing fingers!) you’ll get this pop-up in 20-30 seconds after clicking the apply button:

Click OK again and your new Master data Manager website opens up beautifully in the browser on your server.

Happy Master Data Management!!



5 thoughts on “How to enable Master Data Services (MDS) in SQL Server 2008 R2

  1. Pingback: Regular Expressions, advanced string matching and new Split function SQL Server 2008 R2 « TheFirstSQL

  2. Pingback: Tweets that mention How to enable Master Data Services (MDS) in SQL Server 2008 R2 « TheFirstSQL --

  3. Pingback: SQL 2008 R2 regular expressions | some assembly required, batteries not included

  4. Re: The person who produced the comment that this was a good web site really needs to get their head evaluated.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s