QNE OPTIMUM INSTALLATION (In Network Environment)

• Install QNE OPTIMUM At Server Or Standalone Computer

 Step 1 - Check your Windows System Type by RIGHT Click on My Computer -> Properties

Step 2 - Check System Type

(64-bit Operating System, 86-bit Operating System or 32-bit Operating System)

 Step 3 - Insert QNE SOFTWARE Installer DVD in your DVD ROM drive.

 Step 4 - Open the Windows explorer.

 Step 5 - Double click on Setup_x64 if your computer system type is 64-bit Operating System;

For the rest of System Type, please double click on Setup_x86 file.

Step 6 - In the "Select Setup Language" screen, just click OK to continue.

Step 7 - Click Next when the Setup Welcome screen appears.

 Step 8 - Click Next to install QNE Software in default C drive or else select other destination location by click on “Browse…”

Step 9 - In the installation options page, you select Full Installation which 3 component will selected automatically.

Step 10 - Click Next>

Step 11 - Click Finish as QNE installation completed.

At QNE Server, there has only 3 parts need to configure in order for allow QNE Client connected to QNE Server.

• Part I : SQL Server Configuration Manager

 Step 1 - Go to Start -> SQL Server Configuration Manager

 Step 2 - Select SQL Server Network Configuration -> Protocols for QNEBSS -> On the Right panel, double click on TCP/IP

***NOTE: If TCP/IP disable, please enable it by RIGHT Click -> Select Enable

Step 3 - Click on IP Addresses Tab -> At section IPAll -> TCP Port, Set Port number by key in

1433

• Part II: Add SQL TCP Ports (1433 & 25811) in Window Firewall

Step 1 -  Open Windows Firewall -> Advanced Settings

Step 2 - Click Inbound Rules -> Right Click -> Select New Rule…

Step 3 - Select Port & Click Next>

Step 4 - Add Port TCP, Port number: 1433

Part A: Select TCP

Part B: Key in 1433

Step 5 -Select Allow the connection & Click Next

 Step 6 - Click Next >

Step 7 - Name this new port as “SQL Server Port 1433 (TCP)” and Click Finish.

Step 8 - SQL Port 1433 (TCP) created

Step 9 - Repeat above step 2 until step 15, to add port 10010.

Step 10 - Two new ports added as showed below.

• Part III: Create A Share Folder In C / D Drive

The purpose of creating a share folder is to make sure the Network Recovery Mode is turning on and it allows you to do backup from the workstation. SQL Server require a share folder with Read permission to store the temporary backup file and transfer it to the workstation.

Step 1 - Create a New Folder

Step 2 - Rename New Folder as Shared

RIGHT Click on Shared-> Share With -> Specific people

 Step 3 -  Add user Everyone with Read permission.

• Install QNE OPTIMUM CLIENT At Workstation (PC)

Step 1 - Insert QNE SOFTWARE Installer DVD in your DVD ROM drive.

Step 2 - Open the Windows explorer and double click the Setup.exe

Note: setup.exe do not contain SQL Server and workstation do not require to install SQL Server

Step 3 - In the "Select Setup Language" screen, just click OK to continue.

Step 4 - Click Next when the Setup Welcome screen appears.

Step 5 - Click Next to install QNE Software in default C drive or else select other destination location by click on “Browse…”

 Step 6 - In the installation options page, you select Client Installation

Step 7 - Click Finish as QNE installation completed.

Step 8 - At Database Wizard, Click on Append

Step 9 - Fill up all required field as showed in printscreen below:

Step 10 - Show Success mean this QNE Client connected to QNE server and Click Save.

Step 11 - To open new connected database by click on Open.

Step 12 - Login as Default user ADMIN with no password required.

Step 13 - Click on Upgrade.

Step 14 - Main screen of QNE OPTIMUM showed below that you are successfully access to QNE OPTIMUM.