You can also use MSSQL as a database instead of PostgreSQL.
Video Tutorial:
Make sure your system and software meet the requirements of Samsung.
In addition, we also use the Server Database Manager to access the SQL database.
Install SQL Server 2016
Step 1. Use the basic installation.
Step 2. Continue with the installation process.
Step 3. Close the installation window.
Install Server database manager, this provides a graphical interface
Step 1. Start the installation
A restart is necessary after the installation.
Step 2. Open Microsoft SQL Server Management Studio 18.
Step 3. Connect to the database.
Step 4. Open SQL Server 2016 Configuration Manager.
Step 5. Navigate to SQL Server Network Configuration >> Protocols for MSSQLSERVER.
Right-click TCP/IP and enable it.
Step 6. Restart SQL Server Services.
Step 7. Set security rules.
Right-click on the SQL server and select Properties.
Select Security and then SQL Server and Windows Authentication mode.
Step 8. Restart Services.
Right-click SQL Server and click Restart.
Step 9. Install MagicINFO.
Step 10. Select MSSQL.
When MagicINFO has not created a database you can do the following:
- Open CMD
- Type: sqlcmd
Result 1>
- Navigate to C:MagicInfo Premium/MSSQL/init.bat
Run Init.bat file
- MSSQL Server Management Studio end open magicinfo database
Open the following files in this sequence:
- CreateDBMSSql.sql
- TableCreate.sql
- DataInsert.sql
- InsertOrgan.sql
Execute them one by one