- 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.