| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | |
|---|---|---|---|---|---|---|---|---|---|
Create Database Wizard |
Create Database Wizard (Master Data Services Configuration Manager) |
CordeliaGrey |
jiwang6 |
03/20/2017 |
sql |
master-data-services |
conceptual |
|
[!INCLUDE SQL Server - Windows only ASDBMI]
Use the Create Database wizard to create a [!INCLUDEssMDSshort] database.
Specify information to connect to a local or remote [!INCLUDEssDEnoversion] instance to host 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 SQL Server instance. The credentials you use to connect must be part of the sysadmin server role for the specified [!INCLUDEssNoVersion] instance. For more information about the sysadmin role, see Server-Level Roles. 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 [!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 [!INCLUDEssNoVersion] 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. |
| Test Connection | Verify that the specified user account can connect to the [!INCLUDEssNoVersion] instance and that the account has permission to create a [!INCLUDEssMDSshort] database for that instance. If you do not click Test Connection, the connection will be tested when you click Next. |
Specify a database name and collation options for the new database. Collations in [!INCLUDEssNoVersion] provide sorting rules, case, and accent sensitivity properties for your data. Collations that are used with character data types such as char and varchar dictate the code page and corresponding characters that can be represented for that data type. For more information about database collation, see Collation and Unicode Support.
| Control Name | Description |
|---|---|
| Database name | Specify a name for the [!INCLUDEssMDSshort] database. |
| SQL Server default collation | Select to use the current database collation setting of the specified [!INCLUDEssNoVersion] instance for the new database. |
| Windows collation | Specify the Windows collation settings to use for the new database. Windows collations define rules for storing character data based on an associated Windows locale. For more information about Windows collations and the associated options, see Windows Collation Name (Transact-SQL). Note: The Windows collation list and associated options enable only after you clear the SQL Server default collation box. |
| Control Name | Description |
|---|---|
| User name | Specify the default Super User for [!INCLUDEssMDSshort]. A Super User has access to all functional areas and can add, delete, and update all models. For information about the Super User permission and the other types of administrators in [!INCLUDEssMDSmdm] , see Administrators (Master Data Services). |
Displays a summary of the selected options. Review your selections, and then click Next to begin creating the database with the specified settings.
Displays the progress of the creation process. After the database is created, click Finish to close the database wizard and return to the Databases page. The new database is selected and you can view and modify its system settings.
Database Configuration Page (Master Data Services Configuration Manager)
Master Data Services Installation and Configuration
Database Requirements (Master Data Services)