--- title: "System Settings (Master Data Services) | Microsoft Docs" ms.custom: "" ms.date: "06/13/2017" ms.prod: "sql-server-2014" ms.reviewer: "" ms.technology: master-data-services ms.topic: conceptual helpviewer_keywords: - "Master Data Services, system settings" - "system settings [Master Data Services]" ms.assetid: 83075cdf-f059-4646-8ba2-19be8202f130 author: lrtoyou1223 ms.author: lle manager: craigg --- # System Settings (Master Data Services) For all web applications and web services associated with a [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database, you can configure system settings. Many of these settings can be configured in [!INCLUDE[ssMDScfgmgr](../includes/ssmdscfgmgr-md.md)] on the **Database** page. Others can be configured in the System Settings table (mdm.tblSystemSetting) in the [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database. The settings can be grouped in the following categories: - [General Settings](#General) - [Version Management Settings](#Versions) - [Staging Settings](#Staging) - [Explorer Settings](#Explorer) - [Add-in for Excel Settings](#xls) - [Business Rule Settings](#BusinessRules) - [Notification Settings](#Notifications) - [Security Settings](#Security) - [Not Used](#NotUsed) ## General Settings |Configuration Manager Setting|System Setting|Description| |-----------------------------------|--------------------|-----------------| |**Database connection time-out**|**DatabaseConnectionTimeOut**|The number of seconds the [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database allows for a connection to complete. If the connection does not complete within this time, the connection is cancelled and an error is returned. The default value is **60** seconds (1 minute).| |**Database command time-out**|**DatabaseCommandTimeOut**|The number of seconds the [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database allows for a command to complete. If the command does not complete within this time, the command is cancelled and an error is returned. The default value is **3600** seconds (60 minutes).| |**Web service time-out**|**ServerTimeOut**|The number of seconds ASP.NET allows for a [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] page request to complete. If the request does not complete within this time, the request is cancelled and an error is returned. The default value is **120000** seconds (2000 minutes).| |**Client time-out**|**ClientTimeOut**|The number of seconds of inactivity before [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] returns to the home page. The default value is **300** seconds (5 minutes).| |**Number of rows per batch**|**RowsPerBatch**|The number of records to retrieve in each batch by the web service. The default value is **50**.| ||**ApplicationName**|The text that is displayed in event logs. The default value is **MDM**.| ||**SiteTitle**|The text that is displayed in the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] web browser's title bar. The default value is **Master Data Manager**.| ## Version Management Settings |Configuration Manager Setting|System Setting|Description| |-----------------------------------|--------------------|-----------------| |**Copy only committed versions**|**CopyOnlyCommittedVersion**|In [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)], determines whether users can copy model versions with a status of **Committed**, or versions with any status. The default value is **Yes** or **1**, which indicates that users can copy **Committed** versions only. Change to **No** or **2** to allow users to copy all versions.| For more information, see [Versions (Master Data Services)](versions-master-data-services.md). ## Staging Settings |Configuration Manager Setting|System Setting|Description| |-----------------------------------|--------------------|-----------------| |**Log all staging transactions**|**StagingTransactionLogging**|Applies to SQL Server 2008 R2 only. Determines whether or not transactions are logged when staging records are loaded into the [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database. The default value is **Off** or **2**. Change to **On** or **1** to turn on logging.| |**Staging batch interval**|**StagingBatchInterval**|In the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] **Integration Management** functional area, the number of seconds after you select **Start Batches** that your batch is processed. The default value is **60** seconds (1 minute).| For more information, see [Data Import (Master Data Services)](overview-importing-data-from-tables-master-data-services.md). ## Explorer Settings |Configuration Manager Setting|System Setting|Description| |-----------------------------------|--------------------|-----------------| |**Number of members in the hierarchy by default**|**HierarchyChildNodeLimit**|In the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] **Explorer** functional area, the maximum number of members that are displayed in each hierarchy node before **...more...** is displayed. You can click **...more...** to show the next group of members. The default value is **50**.| |**Show names in hierarchy by default**|**ShowNamesInHierarchy**|In the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] **Explorer** functional area, determines the default setting that is selected when you view hierarchies.

The default value is **Yes** or **1**, which indicates that the name and code of each member are displayed. Change to **No** or **2** to display the code only.| |**Number of domain-based attributes in list**|**DBAListRowLimit**|In the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] **Explorer** functional area, the number of attributes that are displayed in a list when you double-click a domain-based attribute value in the grid. The default value is **50**. If more than 50 members exist, a searchable dialog is displayed instead.| ||**GridFilterDefaultFuzzySimilarityLevel**|In the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] **Explorer** functional area, the level of similarity used when using the **Matches** filter criteria. The default value is **0.3**. Set the value closer to **1** to return a match that is closer to the search criteria. Set to **1** for an exact match.| ## Add-in for Excel Settings |Configuration Manager Setting|System Setting|Description| |-----------------------------------|--------------------|-----------------| |Show Add-in for Excel text on website home page|ShowAddInText|On the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] home page, show a link for users to download the [!INCLUDE[ssMDSXLS](../includes/ssmdsxls-md.md)].| |Add-in for Excel install path on website home page|AddInURL|On the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] home page, if the link to the [!INCLUDE[ssMDSXLS](../includes/ssmdsxls-md.md)] is displayed, the location users go to when they click the link.| ## Business Rule Settings |Configuration Manager Setting|System Setting|Description| |-----------------------------------|--------------------|-----------------| |**Number to increment new business rules by**|**BusinessRuleDefaultPriorityIncrement**|In the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] **System Administration** functional area, the number the priority of each new business rule is incremented by. The default value is **10**.| |**Number of members to apply business rules to**|**BusinessRuleRealtimeMemberCount**|In the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] **Explorer** functional area, the maximum number of members in the grid to apply business rules to. In the [!INCLUDE[ssMDSXLS](../includes/ssmdsxls-md.md)], the maximum number of members in the active worksheet to apply business rules to. The default value is **10000**.| For more information, see [Business Rules (Master Data Services)](../../2014/master-data-services/business-rules-master-data-services.md). ## Notification Settings |Configuration Manager Setting|System Setting|Description| |-----------------------------------|--------------------|-----------------| |**Master Data Manager URL for notifications**|**MDMRootURL**|The URL for the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] web application, which is used in the link in email notifications, for example http://constoso/mds.| |**Notification email interval**|**NotificationInterval**|The frequency, in seconds, that email notifications are sent. The default value is **120** seconds (2 minutes).| |**Number of notifications in a single email**|**NotificationsPerEmail**|The maximum number of validation issues that will be listed in a single notification email. Additional issues, if they exist, are not included in the email, but are available in [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)].| |**Default email format**|**EmailFormat**|The format for all email notifications. The default value is **HTML** or **1**. The database setting of **2** indicates **Text**.

Note: You can override this for an individual user in [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)], by changing and saving the **Email format** on the user's **General** tab.| |**Regular expression for email address**|**EmailRegExPattern**|In the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] **User and Group Permissions** functional area, the regular expression used to validate the email address entered on a user's **General** tab. For more information about regular expressions, see [Regular Expression Language Elements](https://go.microsoft.com/fwlink/?LinkId=164401) in the MSDN library.| |**Database Mail account**|**EmailProfilePrincipalAccount**|Displays the Database Mail account to use when sending email notifications. The default profile is **mds_email_user**.| |**Database Mail profile**|**DatabaseMailProfile**|The Database Mail profile to use when sending email notifications. The default value is blank.| ||**ValidationIssueHTML**|In HTML format, the text of the email users get when a business rule fails validation.| ||**ValidationIssueText**|In plain text format, the text of the email users get when a business rule fails validation.| ||**VersionStatusChangeText**|In plain text format, the text of the email users get when the status of a version changes. Only users with **Update** permission to the entire model receive this email.| ||**VersionStatusChangeHTML**|In HTML format, the text of the email users get when the status of a version changes. Only users with **Update** permission to the entire model receive this email.| For more information, see [Notifications (Master Data Services)](../../2014/master-data-services/notifications-master-data-services.md). ## Security Settings |Configuration Manager Setting|System Setting|Description| |-----------------------------------|--------------------|-----------------| ||**SecurityMemberProcessInterval**|In the [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] **User and Group Permissions** functional area, the frequency, in seconds, that user and group permissions set on the **Hierarchy Members** tab are applied. The default value is **3600** seconds (60 minutes).| For more information, see [Immediately Apply Member Permissions (Master Data Services)](../../2014/master-data-services/immediately-apply-member-permissions-master-data-services.md). ## Not Used The following settings in the System Settings table are not used. - **SecurityMode** - **MDSHubName** - **ApplicationLogging** - **ReportServer** - **ReportDirectory** - **BusinessRuleEngineIterationLimit** - **BusinessRuleExtensibility** - **AttributeExplorerMarkAllActionMemberCount** ## See Also [Database Object Security (Master Data Services)](../../2014/master-data-services/database-object-security-master-data-services.md)