Create a new database
If you want to upgrade from an existing Alfabet release, you can also use an existing Alfabet database in a test environment and update it to Alfabet 11. You can then skip this step.
Prior to installing the Alfabet components, you must create a database on the third-party database server and login must be configured for the database.
This is typically done by a database administrator. The following information is relevant for the setup of the database on the database server:
| Feature | Required setting | |
|---|---|---|
| Unit to host data of a single Alfabet instance | Database | |
| Character set (Recommendation) | SQL_Latin1_General_CP1_CI_AS (recommended for Western Europe and Northern America) | |
| Case-sensitivity | case-insensitive | |
| Rights for the database user used for the Alfabet instance | db_owner role membership Alfabet
default schema: dbo If it is not possible to grant database owner rights to the Alfabet components during normal operations, the following minimum of rights must be granted to the Alfabet components:
Please note however that database owner rights are mandatory to perform meta-model updates and to create or restore databases. During these processes, the database is run in a restricted mode that does not allow any other processes or users to access the database. If database owner rights shall not be granted during normal operations for security reasons, the database permissions must be changed prior to and after migration. |
|
The configuration of access to the database on the database server depends on the login mode used:
-
Standard login requires a user name and password that is configured on the database server for access to the Alfabet database. The user name and password are then added to the server alias configuration for login to the Alfabet database.
Standard login is set up as follows. The information describes the tasks that may fall under the responsibility of different personnel.
Role Task Database Administrator Configure the login parameters for the Alfabet database on the database server and inform the application administrator about the following:
- The user name and password required for login
- The name of the database. Use the notation servername\databasename for a default instance or servername\instancename\databasename for a named instance.
Application Administrator Configure the Alfabet components to use the login parameter when connecting to the Alfabet database. Configuration is done with the tool Alfabet Administrator.
-
The Windows-integrated login mechanism of Microsoft® SQL Servers® allows the Windows login credentials defined on the domain controller in the Active Directory (Active Directory Domain Services on the Windows Server) to be used. The login parameters for Windows-integrated login are secured in the Windows registry.
The information about the Windows integrated login setup describes the tasks that may fall under the responsibility of different personnel.
Role Task Network Administrator Configure a service account for the Alfabet components in the Active Directory on the domain controller. The account must have a non-expiring password. Database Administrator Create a SQL Server login for the service account. Map the login to a database user in the required database with a role granting the required access permissions. Application Administrator/ Web Administrator Set the identity of the application pool used for the Alfabet Web Application to the service account that has the permissions to access the Alfabet database. Application Administrator Make sure that all Alfabet components that log in to the Alfabet database use the service account.