Creating and registering a Microsoft SQL repository database

Right-click in the tree and select the command. The dialog Create Repository opens.

Specify this information:

Name: Specify the name of the new repository registration.

Note: Registrations of the same name are not allowed in Repository Administration.
Configuration: Select the configuration source that will be used to save the repository registration from the drop-down list. You can select the configuration sources User, Computer, Enterprise, or Service.; See Configurations.
Description: Specify the description of the repository registration.

Note:

If the check box Use Computer configuration as default is selected in the Options dialog, new registrations are saved to the configuration source Computer.

See Options.

To create the database and to configure the database connection, click Edit. The dialog Create Repository Database opens.

Select the database server type Microsoft SQL Server from the Database type drop-down list. You can select one of these options:

Microsoft SQL Server
Oracle Database Server
PostgreSQL Server

Note: The connection settings are different for a Microsoft SQL server, an Oracle database server, or a PostgreSQL server.

On the Connection tab, specify this information:

Select SQL server: Select the name of the server on which the new SQL database will be located from the drop-down list.
Enter a system user: A system user is required to create a new schema user or a new Repository database. By default, the check box is selected.
Authentication: Select the authentication method that you use for the system user to log in to theRepository database from the drop-down list. You can select Basic or Windows authentication.
User name: If Basic authentication is selected, specify the name of the system user that is used to log in to the Repository database. If Windows authentication is selected, you do not have to specify a user name and password. The log-in data of the current user is used.
Password: Specify the password of the system user.

Note: Independently from the authentication system, the system user requires the server role sysadmin.

On the Schema tab, specify this information:

Create new schema user: Select this option, if you create a new schema user. Specify a user name and password. By default, this option is selected.
Use existing schema user: Select this option, if you use an existing user as schema user. If Basic authentication is selected, specify the user name and password. If Windows authentication is selected, you do not have to specify a user name and password. The log-in data of the current user is used.
Use system user as schema user: Select this check box, if you use the system user that you have specified on the Connection tab as schema user. You do not have to specify a user name and password.
Authentication: Select the authentication method that you use for the schema user from the drop-down list. You can select Basic or Windows authentication.
User name: If Basic authentication is selected, specify the name and password of the schema user. If Windows authentication is selected, you do not have to specify a user name and password. The log-in data of the current user is used.
Password: Specify the password of the new schema user.
Confirm password: Confirm the password that you specified.
New database: Specify the name of the new Repository database. By default, the option is selected.
Existing database: Select this option, if you create the schema in an existing database. Select the database from the drop-down list.

Note: On database level, the role db_owner must be assigned to the schema user.

On the Options tab, specify the connection settings for the SQL server as required. These settings are standard options for Microsoft SQL databases. For detail information about the settings, see the manual of Microsoft SQL Server.

To check the specified settings, click Validate. If the test is successful, the message The connection test was successful. is displayed. Click OK to save the settings and to close the dialog.

Specify the log-on information of the Repository administrator:

User name: By default, the user name of the Repository administrator is "Admin".
Password: Specify the password of the Repository administrator.
Confirm password: Confirm the password of the Repository administrator.
Save password: Select this check box to save the password of the Repository administrator.

Click Create to start the creation of the new Repository database and registration. If successful, the message The Repository <Repository Name> has been created successfully. is displayed. Click OK. After the creation, the new Repository registration is displayed underneath the node.