Share via


Database Configuration Page (Master Data Services Configuration Manager)

Use the Database Configuration page to edit system settings of a Master Data Services database. System settings affect all web applications and web services associated with the selected Master Data Services database. You must select or create a Master Data Services database before system settings are enabled and available for configuration.

Current Database

Select an existing Master Data Services database or create a new database for which to edit system settings. The new database will be selected after it is created.

Control Name

Description

SQL Server instance

Displays the name of the selected SQL Server instance. This is blank until you connect to an instance, and then select or create a Master Data Services database.

Master Data Services database

Displays the name of the selected Master Data Services database. This is blank until you connect to an instance, and then select or create a Master Data Services database.

Master Data Services database version

The version of the Master Data Services database schema.

Create Database

Opens the Create Database wizard from which you connect to a SQL Server instance and create a Master Data Services database for that instance.

Select Database

Opens the Connect to Database dialog box from which you connect to a SQL Server instance and select a Master Data Services database.

Upgrade Database

Opens a wizard from which you can upgrade a specified Master Data Services database. This button is enabled only when the specified database requires upgrade.

Repair Database

Click this button to ensure the MDS database is installed correctly. This can be useful if you backup and restore an MDS database to a SQL Server instance that has never hosted an MDS database.

System Settings

Edit system settings for all the web applications and web services associated with the selected Master Data Services database.

These settings are available in Master Data Services Configuration Manager and are stored in the database in the System Settings table (mdm.tblSystemSetting). For a list of all settings, see System Settings (Master Data Services).

See Also

Concepts

Master Data Services Configuration Manager

Database Requirements (Master Data Services)