| title | Connect to a MDS Database Dialog Box | |
|---|---|---|
| ms.custom | seo-lt-2019 | |
| ms.date | 03/20/2017 | |
| ms.prod | sql | |
| ms.prod_service | mds | |
| ms.reviewer | ||
| ms.technology | master-data-services | |
| ms.topic | conceptual | |
| f1_keywords |
|
|
| ms.assetid | b2f8c9b9-c31e-4f0d-9095-978709423190 | |
| author | lrtoyou1223 | |
| ms.author | lle |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]
Use the Connect to a Master Data Services Database dialog box to select a [!INCLUDEssMDSshort] database.
In [!INCLUDEssMDScfgmgr], this dialog is available from the following pages:
-
On the Database Configuration page, click Select Database. Use this dialog to select a database for which to configure system settings.
-
On the Web Configuration page, under Associate Application with Database, click Select to select the database to associate with your [!INCLUDEssMDSshort] website or application.
Specify information to connect to a local or remote [!INCLUDEssDEnoversion] instance that hosts the [!INCLUDEssMDSshort] database. To connect to a remote instance, it must be enabled for remote connections.
| Control Name | Description |
|---|---|
| SQL Server instance | Specify the name of the [!INCLUDEssDEnoversion] instance that you want to host the [!INCLUDEssMDSshort] database. This can be a default or named instance on either a local or a remote computer. Specify the information by typing: A period (.) to connect to the default instance on your local computer. The server name or IP address to connect to the default instance on the specified local or remote computer. The server name or IP address, and the instance name to connect to the named instance on the specified local or remote computer. Specify this information in the format server_name\instance_name. |
| Authentication type | Select the type of authentication to use when connecting to the specified [!INCLUDEssNoVersion] instance. The credentials that you use to connect determine the databases that are displayed in the Master Data Services database drop-down list. The authentication types include: Current User - Integrated Security: Uses Integrated Windows Authentication to connect by using the credentials of the current Windows user account. [!INCLUDEssMDScfgmgr] uses the Windows credentials of the user who logged on to the computer and opened the application. You cannot specify different Windows credentials in the application. If you want to connect with different Windows credentials, you must log on to the computer as that user and then open the [!INCLUDEssMDScfgmgr]. SQL Server Account: Uses a SQL Server account to connect. When you select this option, the User name and Password fields are enabled and you must specify credentials for a [!INCLUDEssNoVersion] account on the specified [!INCLUDEssNoVersion] instance. |
| User name | Specify the name of the user account that will be used to connect to the specified SQL Server instance. The account must be part of the sysadmin role on the specified [!INCLUDEssNoVersion] instance: When the Authentication type is Current User - Integrated Security, the User name box is read-only and it displays the name of the Windows user account that is logged on to the computer. When the Authentication type is SQL Server Account, the User name box is enabled and you must specify credentials for a [!INCLUDEssNoVersion] account on the specified [!INCLUDEssNoVersion] instance. |
| Password | Specify the password associated with the user account: When the Authentication type is Current User - Integrated Security, the Password box is read-only and credentials of the specified Windows user account are used to connect. When the Authentication type is SQL Server Account, the Password box is enabled and you must specify the password associated with the specified user account. |
| Connect | Connect to the [!INCLUDEssNoVersion] instance with the specified credentials. |
| Master Data Services database | Displays the [!INCLUDEssMDSshort] databases in the specified [!INCLUDEssNoVersion] instance based on the following criteria: When the user is a member of the sysadmin server role for that instance, all [!INCLUDEssMDSshort] databases in that instance are displayed. When the user is a member of the db_owner database role for any [!INCLUDEssMDSshort] databases in that instance, those [!INCLUDEssMDSshort] databases are displayed. For more information about SQL Server roles, see Server-Level Roles and Database-Level Roles. |
Database Configuration Page (Master Data Services Configuration Manager)