Database Reference
In-Depth Information
The MDM web application and web services prerequisites are as follows:
F MDM is a web application hosted by IIS
F On a Windows Server 2008 or Windows Server 2008 R2 machine, use Server
Manager to install Web Server (IIS) role and refer to http://msdn.microsoft.
com/en-us/library/e e633744.aspx for the required role services
The MDS database prerequisites are as follows:
F MDS requires a database to support MDM web applications and web services
F In this recipe, the machine that hosts an MDS database is using an instance of SQL
Server 2008 R2 database engine
How to do it...
To implement the Master Data Management solution, MDS must be installed, which has two
main components, an MDS database component and an MDS web component. Ensure that
all of the prerequisites (mentioned in the earlier sections) are in place and by default the MDS
is not installed as a part of the regular SQL Server 2008 R2 installation. We need to install the
MDS separately as follows:
F On the SQL Server 2008 R2 installation media, navigate to the
\ MasterDataServices\X64\1033_ENU folder and double-click on
masterdataservices.msi file that will present a welcome screen
F Similar to the SQL Server installation screens, the MDS setup requires default
information on the remaining steps that are self-explanatory
F The presented screens are License Agreement, Registration Information, Feature
selection, and Ready to install to complete the Master Data Services installation
Now that we have installed the Master Data Services components on the server, we need to
configure the MDS to make it available for use.
1. The MDM configuration is implemented as a two-fold phase: Databases and
Web Configuration.
2. To launch the MDS configuration manager, go to Start | All Programs | SQL Server
2008 R2 | Master Data Services | Configuration Manager.
 
Search WWH ::




Custom Search