Change the database connection in the server alias
For each Alfabet component, the connection to the Alfabet database the component connects to is defined in the server alias configuration of the component in the Database Settings tab of the server alias configuration. The server alias configuration is stored in the file AlfabetMS.xml that must be located in the working directory of the component, or, for the Alfabet Web Application, at the location defined in the alfabet.config configuration file of the Alfabet Web Application.
For an existing server alias configuration, the database connection settings can be changed via AlfaAdministratorConsole.exe with the following command line:
- AlfaAdministratorConsole.exe -msalias <alias name> -db_set_connection -DbDriver SqlServer -DbUser <database user name> -DBPassword <database user password> -DbEncryptConnection <true|false> -DbCleanInvalidChars <true|false> - DbDatabase <database name>
The table below displays the command line options:
| Command Line Option | Mandatory/ Default | Explanation |
|---|---|---|
| -db_set_connection | Mandatory | To change the database connection information in the server alias configuration:
|
| -msalias <alias name> | Mandatory | Enter the server alias name as specified in the AlfabetMS.xml configuration file for access to the database. |
| -msaliasesfile <Alfabet configuration file path> | Optional | If the alfabetMS.xml configuration file that contains the specification of the alias is not located in the same directory as the executable, the path to the alfabetMS.xml file must be specified with this parameter. |
| -DbDriver SqlServer | Mandatory | Enter SqlServer as driver type |
| -DbUser <database user name> | Mandatory | Specify the user name for access to the Alfabet database on the database server. For Oracle® databases, the user name is identical to the schema name. |
| -DbPassword <database user password> | Mandatory | Specify the password for access to the Alfabet database on the database server. |
| -DbEncryptConnection <true|false> | Optional | If the parameter is set to true, SSL/TLS will be applied to the connections between the Alfabet component and the Alfabet database. If the parameter is not defined in the command line, it is set to false in the server alias configuration. |
| -DbCleanInvalidChars <true|false> | Optional | Set this command line option to true if you want strings to be checked for validity prior to check-in or when reading the string from the Alfabet database. If the parameter is not defined in the command line, it is set to false in the server alias configuration. |
| -DbDatabase <database name> | Mandatory | Enter the name of the Alfabet database. Use the notation servername\databasename for a default instance or servername\instancename\databasename for a named instance. |
If the command is not correctly specified, the command line tool returns error messages in the command prompt.