Create Database Wizard (Master Data Services Configuration Manager)
Use the Create Database wizard to create a Master Data Services database.
Specify information to connect to a local or remote SQL Server Database Engine instance to host the Master Data Services database. To connect to a remote instance, it must be enabled for remote connections.
SQL Server instance
Specify the name of the SQL Server Database Engine instance that you want to host the Master Data Services database. This can be a default or named instance on either a local or a remote computer. Specify the information by typing:
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 SQL Server instance. For more information about the sysadmin role, see Server-Level Roles.
The authentication types include:
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 SQL Server instance.
Specify the password associated with the user account.
Verify that the specified user account can connect to the SQL Server instance and that the account has permission to create a Master Data Services 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 SQL Server 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 International Terminology.
Specify a name for the Master Data Services database.
SQL Server default collation
Select to use the current database collation setting of the specified SQL Server instance for the new database.
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 Sorting Styles.
The Windows collation list and associated options enable only after you clear the SQL Server default collation box.
Specify a service account to add to the mds_exec database role in the Master Data Services database. This should be the same account that you will specify for the application pool when you create the Master Data Manager Web application. For more information, see Database Logins, Users, and Roles (Master Data Services).
Specify a domain user account to be the Master Data Services system administrator. For all Master Data Manager 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).