Select either PostgreSQL or Microsoft SQL Server as the database and install MagicINFO Server.

Installing the software for PostgreSQL

Please read the following if you plan to install 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 the SQL Server network

  1. Run SQL Server Configuration Manager.

  2. Set Named Pipe and TCP/IP under SQL EXPRESS to enable.

  3. Delete the TCP Dynamic Ports values from IP1~IP7 and IP All. (Default value: 0)

  4. Set TCP port for IP1~IP7 and IP All to 1433.

  5. After configuring the network, make sure to restart the SQL Server.

SQL Server authentication

  1. Run SQL Server Management Studio.

  2. Set the authentication mode for SQL Server to SQL Server and Windows Authentication mode.

  3. After specifying the authentication mode, make sure to restart the SQL Server.