Install MI with MSSQL database

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
image-1611149777313.png

- Continue with the installation process
- Close installation window
image-1611149803599.png

Install Server database manager, this provides a graphical interface
- Start the installation
image-1611149824820.png

- Restart is necessary after the installation
- Open Microsoft SQL Server Management Studio 18
image-1611149844346.png

- Connect to the database
image-1611149871047.png

- Open SQL Server 2016 Configuration manager
image-1611149882155.png

- Navigate to SQL Server Network Configuration>Protocols for MSSQLSERVER
Right-click TCP/IP and enable this
image-1611149911907.png

- Restart SQL Server Services
image-1611149921108.png

- Set security rules
- Right-click on the SQL server and select Properties
image-1611149934355.png

- Select Security and then SQL Server and Windows Authentication mode
image-1611149956213.png

- Restart Services
- Right-click SQL Server and click Restart
image-1611149970080.png

- Install MI
image-1611149986420.png

- Select SQL
image-1611149996780.png

- 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
image-1611150028241.png

- Open the following files in this sequence
CreateDBMSSql.sql
TableCreate.sql
DataInsert.sql
InsertOrgan.sql
Execute them one by one
image-1611150042335.png