THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Master Data Services Team

Blog for the Microsoft SQL Server Master Data Services (MDS) team. Blog posts are contributed by various team members.

Installing and Configuring Master Data Services 2008 R2 November CTP

(this post was contributed by Matt Anderson, Senior Software Engineer on the MDS team)
 

Master Data Services (MDS) is now available as part of the November CTP of Microsoft® SQL Server® 2008 R2! An overview of MDS can be found on the product home page and documentation is available in SQL Server Books Online.
 

This post covers the basic steps for installing and configuring MDS as well as some behind-the-scenes information about what is happening and why. Please let us know your thoughts about the install and configuration experience and any questions you have.
 

Background

Master Data Services consists of an ASP.NET web application (Master Data Manager), a WCF service hosted in IIS, and a SQL Server 2008 R2 database. MDS web and database components can be installed on a single server or on multiple servers. MasterDataServices.msi installs the pages, database scripts, samples, and assemblies for MDS, and a separate utility called Configuration Manager is used to create MDS web applications and databases.
 

Installation
 

  1. Install one of the supported Windows operating systems for MDS.
     
    NOTE: MDS is supported on x64 operating systems only.
     
  2. Install the Web Server (IIS) role on the machine that will host the MDS web site. Ensure that both the ASP.NET and Windows Authentication role services are installed as well. For a list of the specific role services and features, see Web Application Considerations (Master Data Services) in SQL Server Books Online. 
     
    image
    The MDS Web application and WCF service require Windows Authentication. Active Directory users and groups can be assigned permissions in MDS to control access to features and data. Local users and groups can also be used in a single machine (i.e., development or test) environment.
     
  3. Locate and run the MasterDataServices.msi. The location for the msi varies based on how you downloaded MDS:
     
    • DVD Image: <drive>:\MasterDataServices\x64\1033_ENU\MasterDataServices.msi
       
    • Self-extracting executable: <extract location>\1033_enu_lp\x64\setup\masterdataservices.msi
       
    • MasterDataServices.msi download: Wherever you saved the msi during download 
       
       image
  4. Follow the steps in the wizard to install the MDS pages, database scripts, samples, and assemblies. No web applications or databases are created during the installation. Those tasks are done using Configuration Manager, which is started automatically at the end of the wizard.

    After the install, you should find that the MDS pages, scripts, and assemblies are in the target location selected during the install wizard. 
     

    image


    The MDS assemblies and resource should also be present in the Global Assembly Cache:

    image 

Configuration
 

  1. The MDS Configuration Manager is started automatically at the end of the installation. If you want to start it manually, click the Start menu link: Start –> All Programs –> Microsoft SQL Server 2008 R2 November CTP –> Master Data Services –> Configuration Manager

    image 
  2. Review the status information shown in the “Server Configuration” panel to ensure that the required components are found on the machine.
     
  3. Click “Databases” in the left pane and then click the “Create Database” button to start the Create Database wizard. Follow the steps in the wizard and supply the required information to create a new MDS database. For more information about the requirements for a computer that hosts the Master Data Services database and the options in the wizard, see Database Considerations (Master Data Services) and Create Database Wizard (Master Data Services) in SQL Server Books Online. 

    NOTE: The MDS web application uses Windows Authentication to connect to the MDS database. The “Service Account” step in the wizard allows you to specify the Windows user that should be used for this connection. The service account will be granted the correct permissions in the newly created MDS database and should also be configured as the identity for the MDS Application Pool in IIS when the MDS web application is created (see step 5.2 below). The service account should be a low privilege domain account that can connect to the database server hosting the MDS database.

    NOTE: The “Administrator Account” is the user that should have full access to all MDS functions and data. During database creation the specified account will be granted these permissions.

    Database creation can take several minutes as the required objects are created and system data is inserted. 
     
  4. After the database is created, various system settings can be adjusted. For more information about system settings, see Database Page (Master Data Services) in SQL Server Books Online.

    image
  5. Click “Web Configuration” in the left pane to configure a new IIS web application for MDS. The MDS web application can be created as its own web site (i.e., root application) or within another web site. For more information about the options on the Web Configuration page, see Web Configuration Page (Master Data Services) in SQL Server Books Online.
     
    The simplest configuration is to create the MDS web application within the existing Default Web Site, which is described below:
     
    1. Select “Default Web Site” in the Web Site drop down list.
       
    2. Click the Create Application… button to create a new MDS web application. Accept the defaults for web application Alias and Application Pool Name unless you have reason to change them. Type the User name and Password for the identity of the MDS application pool. This should be the same account as provided in the Service Account step of the Create Database wizard (see step 3 above). Click the OK button to create the new web application.

       image
    3. Within the Database section of the Web Configuration page, click the Select… button. Then, in the Connect to Database dialog, connect to the database server hosting the MDS database and select the MDS database. Click the OK button to select the database for the MDS web application.

      image
    4. Within the Web Services section of the Web Configuration page, check the “Enable Web services for this Web application.” checkbox if you would like to expose the MDS WCF application programming interface for this web application.

      NOTE: If you plan to create custom solutions using this API, you should enable the web services. Otherwise, leave them disabled to reduce the surface area of the MDS instance. The Master Data Manager web UI does not require the services to be enabled.
       
    5. Click the Apply button to save the Web Application settings. In the Configuration Complete dialog, optionally check the Launch Web application in browser window to open Master Data Manager for the web application and then click OK.

      The Web Configuration should look similar to that shown below:

       image 
       

If you chose to launch the web application, you will be taken to the MDS getting started page. Click the Open the Master Data Manager home page link to open the Master Data Manager.


                                         Master Data Manager Getting Started Page

image

  

                                           Master Data Manager Home Page

image

Although not shown above, multiple MDS web applications and databases can be created using Configuration Manager. This can be useful when you want to configure development, test, and staging environments. You can also use Configuration Manager to change the database that should be used for an MDS web application.

NOTE: Configuration Manager can create databases on remote database servers, but it can only create web applications on the server where it is running. As a result, you will need to run Configuration Manager separately on each server that is hosting one or more MDS web applications.


Next Steps 
MDS installation and configuration are complete. Some suggested next steps are listed below.  
 

  1. If this is a production MDS instance, setup a database maintenance plan and backup schedule. The maintenance plan should include updating statistics on the database.
     
  2. If this is a production MDS instance and/or it contains production data, configure the MDS web application to use TLS/SSL to help protect the master data as it is transferred across your network.
     
  3. Create and configure the mail profile for the MDS instance if you want to enable email notifications.
     
  4. Deploy sample package(s) into the MDS instance.
Published Thursday, December 10, 2009 2:46 PM by mattande
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Master Data Services Team said:

(this post was contributed by Val Lovicz, Principal Program Manager on the MDS Team) With the November

January 12, 2010 8:19 PM
 

Ben Daley said:

Regarding the point that MDS is supported on x64 only - is this only a support issue, or can it simply not be installed on an x86 OS?

January 18, 2010 8:41 AM
 

mattande said:

Hi Ben,

MDS cannot be installed on x86 operating systems because the released binaries are x64 only.

Matt

January 18, 2010 11:14 AM
 

Master Data Services Team said:

(this post was contributed by Nick Nieslanik, Senior Software Engineer on the MDS team). Many production

February 5, 2010 12:29 PM
 

Valentino Vranken said:

To the MDS Team: thanks for the info, very useful!

To anyone reading this: in case you're faced with the "HTTP Error 401.2 – Unauthorized" issue, I've recently encountered it as well and described it a bit on my blog (http://blog.hoegaerden.be/2010/02/14/iis-7-5-and-windows-authentication/).

Regards,

Valentino.

February 14, 2010 6:41 AM
 

Abhishek Madan said:

Is IIS 7.0 or above a minimum requirement for MDS? Is there a way I could run MDS using IIS 6.0? I've got Windows Server 2003 x64 as the OS...

February 26, 2010 7:33 AM
 

mattande said:

(This comment was contributed by Reagan Templin, Technical Writer for the MDS Team) Yes, IIS 7.0 or later is a requirement for MDS, so you must have an OS that meets the requirements as listed in the linked topic above (http://msdn.microsoft.com/en-us/library/ee633742(SQL.105).aspx). This is because MDS requires the functionality provided in IIS 7.0 and later, such as app pools that run in integrated mode for request-processing.

March 1, 2010 5:19 PM
 

Xavier said:

Great help  Valentino

October 3, 2010 12:57 AM
 

Kjarr said:

"Is IIS 7.0 or above a minimum requirement for MDS? Is there a way I could run MDS using IIS 6.0? I've got Windows Server 2003 x64 as the OS..."

Ans: MDS is NOT supported on Windows Server 2003.

December 7, 2010 2:17 PM
 

Pierre said:

Is is required to have a windows domain in order to install Master Data Manager ? is there a workaround to install master data service on a domain-less machine ?

February 17, 2011 5:25 AM
 

Chakri said:

Now Available link in not working. now where can i get the .msi file

March 25, 2011 7:29 AM
 

Hennie said:

Great article. thnx

July 1, 2012 2:28 PM

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement