You can also use MSSQL as a database instead of PostgreSQL.
Make sure your system and software meet the requirements from Samsung
http://displaysolutions.samsung.com/docs/pages/viewpage.action?pageId=2064870
In addition, we use also the Server database manager to access the SQL database.
Install SQL server 2016
- We use the basic installation
- Continue with the installation process
- Close installation window
Install Server database manager, this provides a graphical interface
- Start the installation
- Restart is necessary after the installation
- Open Microsoft SQL Server Management Studio 18
- Connect to the database
- Open SQL Server 2016 Configuration manager
- Navigate to SQL Server Network Configuration>Protocols for MSSQLSERVER
Right-click TCP/IP and enable this
- Restart SQL Server Services
- Set security rules
- Right-click on the SQL server and select Properties
- Select Security and then SQL Server and Windows Authentication mode
- Restart Services
- Right-click SQL Server and click Restart
- Install MI
- Select SQL
- 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