Database Requirements (Master Data Services)
Master Data Services requires a database to support the Master Data Manager Web application and Web services. The computer that hosts the Master Data Services 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. You can move the database from one environment to another, and if you connect the Master Data Services Web service and Master Data Manager to the database, you can maintain the information in a new environment.
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 2008 R2.
The following list contains the SQL Server versions and editions on which you can host the Master Data Services database:
SQL Server 2008 R2 Datacenter
SQL Server 2008 R2 Enterprise
SQL Server 2008 R2 Developer
SQL Server 2008 R2 Developer is for development purposes only.
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.
When you create a Master Data Services database in Master Data Services Configuration Manager, you must specify a service account for database access. This account is added to the mds_exec database role in the Master Data Services database. This should be the same account that you will specify for the application pool when you create the Master Data Manager Web application. For more information, see Database Logins, Users, and Roles (Master Data Services).
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).