Create Database
A new database can be created as follows:
Automated with SQL Server
Administrator rights to the SQL Server instance are needed.
Manually with SQL Server
Administrator rights to the SQL Server instance are needed.
Manually with Oracle
Administrator rights to the Oracle database server are needed.
Default User
During the creation of the database, a user account is created automatically: The user Admin (with the starting password password) is a super user for administrating ADOIT.
For detailed instructions on how to create a database with SQL Server 2012/2014/2016/2017/2019/2022 or Oracle 12c/18c/19c, refer to the database manuals on the ADOIT installation medium in the folder “01 Installation Manual”.
Quick guide: Automated with SQL Server
Start the ADOIT-tool Create new database in the windows start menu or execute the file
adbinstws.exe
in the ADOIT installation directory.Select Create new database, fill out the available fields, keep the default settings and click Create.
Quick guide: Manually with SQL Server
Create an empty database hull with the SQL Server Management Studio.
Establish an ODBC-data source. For details, see the information box below.
Initialize the database (see Initialize Database).
You must create the ODBC data source by using the 64-bit version of the odbcad32.exe
file located
in the “%WINDIR%\system32” folder. “%WINDIR%” stands for your Windows installation directory.
The 64-bit version of the odbcad32.exe
file is supported from ADOIT 10.0. Older versions of ADOIT
require the 32-bit version of the odbcad32.exe
file to connect to the database.
Quick guide: Manually with Oracle
Run the Oracle Database Configuration Assistant.
Create a net service name.
Modify the script
aprporcl.sql
and run it with SQL Plus.Initialize the database (see Initialize Database).