Registering a Microsoft SQL repository database

You use the New Registration command to register a Microsoft SQL repository database. The registration contains the information to connect to the selected database.

To register a Microsoft SQL repository database:

Right-click Repository Registrations in the tree and select the New Registration command. The New Registration dialog 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 configure the database connection, click Edit. The dialog Database Connection opens.
Select Microsoft SQL Server from the Database type drop-down list.
On the Connection tab, select the server on which the SQL database is located from the drop-down list.
On the Schema tab, specify this information:

Authentication

Select the authentication method that you use for the schema user from the drop-down list. You can select Basic or Windows.

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 schema user.

Select database

Select the Repository 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:

Authentication

By default, the authentication method that you use for the Repository administrator is Basic.

User name

Specify the user name of the Repository administrator.

Password

Specify 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 registration. After the creation, the new Repository registration is displayed underneath the Repository Registrations node.