Creating the Master Data Services database

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

 

image

 

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.

 

image

 

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:

 

image

 

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

image

 

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:

 

image

 

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

 

image

 

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

Advertisements