Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Creating the Master Data Services database

  • 4 June 2013
  • Author: Chris Schmidt
  • Number of views: 6267

In 2008R2, Microsoft added Master Data Services to the SQL Server installation (as it’s own separate install file), but it wasn’t until the 2012 release that we got a nice product that we can install along with the rest of the SQL Server Features. In 2012, Master Data Services is a checkbox during the installation (instead of being it’s own separate installer), but it’s an awesome tool that has opened up the doors of Master Data Management to the masses. Once you install Master Data Services, you need to run the installer to set up the database so that you can start to use the product. This blog post is intended to be an overview of how to install and configure the Master Data Services database in SQL Server.


To start, go to start –> All Programs –> SQL Server 2012 –> Master Data Services –> Master Data Services Configuration Manager




Once you open it, click on the Database Configuration tab on the left, and then click on “Create Database” over to the upper right hand side.




Clicking “Create Database” opens up the Create Database Wizard. On the initial screen click Next. On the next screen type of the name of your SQL Server instance where you want to install Master Data Services to and the authentication information you want to use:




Click Next, and give your database a name. Change the collation properties off of the default if you want.



Click Next again, and specify an administrator for your database. Once you’ve done that click next again and it will validate the user. The Summary screen will appear:




Click Next, and the Progress and Finish section will run:




Click Finish, and then go to the instance where you installed it. The database has now been created. Easy as 1-2-3!

Categories: Analysis Services
Rate this article:
No rating

Please login or register to post comments.