MagicINFO Server can be installed after selecting any of PostgreSQL and Microsoft SQL Server.
Installing the software for PostgreSQL
Be sure to read the following if you install the PostgreSQL database before installing MagicINFO Server.
- The Secondary Logon service must be enabled on your computer to successfully install PostgreSQL.
Before installing PostgreSQL, click Control Panel > User Accounts > Change User Account Control settings from the Start menu. Select "Never notify" for "Choose when to be notified about changes to your computer" for proper installation.
- The PostgreSQL port and administrator account password set during PostgreSQL installation are also required for MagicINFO Server installation. Remember these for future use.
Installing the software for Microsoft SQL Server
To install MagicINFO Server, you must first configure the MicroSoft SQL Server network and authentication settings.
Configuring SQL Server network
- Run SQL Server Configuration Manager.
- Set Named Pipe and TCP/IP under SQL EXPRESS to enable.
- Delete the TCP Dynamic Ports values from IP1-IP7 and IP All. (Default value: 0)
- Set TCP port for IP1~IP7 and IP All to 1433.
- After configuring the network, be sure to restart the SQL Server.
SQL Server authentication
- Run SQL Server Management Studio.
- Set the authentication mode for SQL Server to SQL Server and Windows Authentication mode.
- After specifying the authentication mode, make sure to restart SQL Server.