Skip to content

Latest commit

 

History

History
70 lines (46 loc) · 5.53 KB

database-requirements-master-data-services.md

File metadata and controls

70 lines (46 loc) · 5.53 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic
Database Requirements
Use Master Data Services Configuration Manager to create and configure the Master Data Services database, which stores all master data.
CordeliaGrey
jiwang6
03/14/2017
sql
master-data-services
conceptual

Database Requirements (Master Data Services)

[!INCLUDE SQL Server Windows Only - ASDBMI]

All master data is stored in a [!INCLUDEssMDSshort] database. The computer that hosts this database must run an instance of [!INCLUDEssNoVersion] [!INCLUDEssDE].

Use [!INCLUDEssMDScfgmgr] to create and configure the [!INCLUDEssMDSshort] 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 [!INCLUDEssMDSshort] web service and [!INCLUDEssMDSmdm] to the database in its new location.

Note

Any computer on which you install components of [!INCLUDEssMDSshort] must be licensed. For more information, refer to the End User License Agreement (EULA).

Requirements

Before you create a [!INCLUDEssMDSshort] database, ensure the following requirements are met.

SQL Server Edition

The [!INCLUDEssMDSshort] database can be hosted on the following editions of [!INCLUDEssNoVersion]:

  • [!INCLUDEsssql16-md] Enterprise (64-bit) x64

  • [!INCLUDEsssql16-md] Developer (64-bit) x64

  • [!INCLUDEssSQL14] Business Intelligence (64-bit) x64

  • [!INCLUDEssSQL14] Enterprise (64-bit) x64

  • [!INCLUDEssSQL14] Developer (64-bit) x64

  • [!INCLUDEssSQL11] Business Intelligence (64-bit) x64

  • [!INCLUDEssSQL11] Enterprise (64-bit) x64 - Upgrade from [!INCLUDEsql2008r2] Enterprise only

  • [!INCLUDEssSQL11] Developer (64-bit) x64

  • Microsoft SQL Server 2008 R2 Enterprise (64-bit) x64

  • Microsoft SQL Server 2008 R2 Developer (64-bit) x64

[!INCLUDE editions-supported-features-windows]

Operating System

For information about the supported Windows operating systems and other requirements for [!INCLUDEssNoVersion] [!INCLUDEssDE], see Hardware and Software Requirements for Installing SQL Server 2016.

Accounts and Permissions

Type Description
User account In [!INCLUDEssMDScfgmgr], you can use a Windows account or a [!INCLUDEssNoVersion] account to connect to the [!INCLUDEssDE] instance of [!INCLUDEssNoVersion] to host the [!INCLUDEssMDSshort] database. The user account must belong to the sysadmin server role on the instance of [!INCLUDEssNoVersion] [!INCLUDEssDE]. For more information about the sysadmin role, see Server-Level Roles.
[!INCLUDEssMDSmdm] administrator account When you create a [!INCLUDEssMDSshort] database, you must specify a domain user account to be the [!INCLUDEssMDSshort] system administrator. For all [!INCLUDEssMDSmdm] 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).

Database Backup

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).

See Also

Install Master Data Services
Create a Master Data Services Database
Master Data Services Database
Connect to a Master Data Services Database Dialog Box
Create Database Wizard (Master Data Services Configuration Manager)