Perform the following steps if you want to set up a log in via a direct connection to the database.
To create a new connection to the database
-
Start a One Identity Manager tool, such as the Database Compiler, from the install directory.
This opens the connection dialog.
-
In the connection dialog, under Select a database connection, click Add new connection and select the SQL Server system type.
-
Click Next.
-
Enter the connection data for the database server.
-
Server: Database server.
-
Windows authentication: (Optional) Specifies whether the integrated Windows authentication is used. This type of authentication is not recommended. If you decide to use it anyway, ensure that your environment supports Windows authentication.
-
User: User's SQL login name.
-
Password: Password for the SQL user's login.
-
Database: List of possible databases on the database server. Select the database.
-
Encrypt communication: Specifies whether encryption is required for exchanging data between the client and server. Select the minimum encryption level. The encryption level that is actually used depends on the database server configuration. For more information, see the documentation from Microsoft.
Permitted values are:
-
Optional: Communication is not encrypted.
-
Mandatory: Data exchange is encrypted. The Trust server certificate option, allows you to also specify whether to verify the server certificate.
-
Strict (SQL Server 2022 and Azure SQL): The data exchange is encrypted. The server certificate is always verified.
-
Trust server certificate: If this option is enabled, the data exchange between the client and server is encrypted. However, the server certificate is not verified.
-
Select Test connection in the Options menu.
This attempts to connect the database with the given connection data. You are prompted to confirm a message about the test.
NOTE: Using Options > Advanced options item, you can make additional changes to the connection configuration.
-
Click Finished.
-
In the connection dialog, under Authentication method, select the authentication module.
This displays a list of all available authentication modules.
-
Enter the login data for the system user ID.
The login data required depends on which authentication module you select.
-
Click Connect.
NOTE: The connection is saved and made available for the next login.
NOTE: Newly created connections are not shown in the connection dialog until the program has been restarted.
NOTE: Connections that do not use the expected access level for SQL logins are not shown in the connection dialog. The access level for an existing connection is shown in the menu item's tooltip. For more information about the minimum access levels of One Identity Manager tools, see the One Identity Manager Authorization and Authentication Guide.
NOTE: When you start the program, it tries to restore the last used connection. This may lead to a delay resulting in an error if you frequently swap between connections to other database servers.
To prevent the previous connection restoring, create the following registry key:
HKEY_CURRENT_USER\Software\One Identity\One Identity Manager\Global\Settings\[RestoreLastConnection]="false"
To select an existing login connection
-
Start a One Identity Manager tool, such as the Manager, from the install directory.
This opens the connection dialog.
-
In the connection dialog, select the connection under Select a database connection.
-
In the connection dialog, under Authentication method, select the authentication module.
This displays a list of all available authentication modules.
-
Enter the login data for the system user ID.
The login data required depends on which authentication module you select.
-
Click Connect.
To delete a connection in the connection dialog
-
In the connection dialog, select the connection under Select database connection.
-
Press DEL.
-
Confirm the security prompt with Yes.
The connection is no longer shown in the connection dialog.
To delete an SQL Server from the server list in the connection dialog
-
In the connection dialog, under Select a database connection, click Add new connection and select the SQL Server system type.
-
Click Next.
-
Open the Server drop-down and mark the server you want to delete.
-
Press the Del key.
-
Confirm the security prompt with Yes.
This removes the SQL Server from the list.
To use an authentication module for logging in, you must enable the authentication module. Perform the following steps to enable an authentication module.
To enable an authentication module
-
In the Designer, select the Base data > Security settings > Authentication modules category.
-
In the List Editor, select the authentication module.
-
In the Properties view, set the Activated property to True.
-
Select the Database > Save to database and click Save.
For more information about One Identity Manager authentication modules, see the One Identity Manager Authorization and Authentication Guide.
The default One Identity Manager installation is supplied in the English - United States [en-US] and German - Germany [de-DE] language. You can add other languages to the user interface and display text if required. In this instance, you must translate the text before One Identity Manager goes live. There is a Language Editor in the Designer to help you do this. A special control is provided in the One Identity Manager tools that aids multi-language input.
One Identity Manager default language
Maintenance of default data takes place in the default language. The default language for an installation of One Identity Manager is English - United States [en-US]. The default language is valid across the system. It is not recommended to change the default language during working hours.
In the ideal case, the One Identity Manager language matches the user’s administration tool login language. If these two settings are different, then the default language is used if no captions are found in the requested login language for a set of language-dependent data.
User login language
The language used in the user interface is the same as the language used when logging in to the administration tools. When you log in for the first time, the system language is used for displaying the user interface. Users can change their login language in the program settings in all administration tools. This sets the language globally for all the user’s tools. Therefore, the user does not have to set the login language in every tool separately. Changes to the login language take effect after the tool is restarted.
Any language for which the Select in front-end option is activated can be used as a login language.
