Database Requirements (Master Data Services)
All master data is stored in a Master Data Services database. The computer that hosts this database must run an instance of SQL Server Database Engine.
Use Master Data Services Configuration Manager to create and configure the Master Data Services database on either a local or a remote computer. If you move the database from one environment to another, you can maintain the information in a new environment by associating the Master Data Services web service and Master Data Manager to the database in its new location.
Any computer on which you install components of Master Data Services must be licensed. For more information, refer to the End User License Agreement (EULA).
Before you create a Master Data Services database, ensure the following requirements are met.
SQL Server Edition
The Master Data Services database can be hosted on the following editions of SQL Server:
SQL Server 2012 Business Intelligence (64-bit) x64
SQL Server 2012 Enterprise (64-bit) x64 – Upgrade from SQL Server 2008 R2 Enterprise only
SQL Server 2012 Developer (64-bit) x64
Microsoft SQL Server 2008 R2 Enterprise (64-bit) x64
Microsoft SQL Server 2008 R2 Developer (64-bit) x64
For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2012.
For information about the supported Windows operating systems and other requirements for SQL Server Database Engine, see Hardware and Software Requirements for Installing SQL Server 2012.
Accounts and Permissions
In Master Data Services Configuration Manager, you can use a Windows account or a SQL Server account to connect to the Database Engine instance of SQL Server to host the Master Data Services database. The user account must belong to the sysadmin server role on the instance of SQL Server Database Engine. For more information about the sysadmin role, see Server-Level Roles.
Master Data Manager administrator account
When you create a Master Data Services database, you must specify a domain user account to be the Master Data Services system administrator. For all Master Data Manager web applications associated with this database, this user can update all models and all data in all functional areas. For more information, see Administrators (Master Data Services).
As a best practice, back up the full database daily at a time of low activity and back up transaction logs more frequently depending on the needs of your environment. For more information about database backups, see Backup Overview (SQL Server).