Skip to content

Private Cloud

Big Picture

Big Picture


Quick Checklist

  1. Make sure the client has fiber internet (MAXIS, UNIFI, TIME). (STRICTLY NO STREAMYX/BROADBAND/UNIFI LITE)
  2. Will need 2 IP Address. (1 for Windows & 1 for Debian 9 Virtual Machine)
    • If no special requirements, may leave it empty in the checklist. We will assign them accordingly.
  3. Port forwarding will be done on the Debian 9 VM.
    • If not sure how to configure this, may leave it empty in the checklist. We will help in configuring it.
  4. Enable virtualization in the BIOS. Here's how you can check if you have enabled it.

    Check BIOS Virtualization

  5. If it is not enabled, you may need to enter BIOS to switch it on. Here's how you can enter your server's BIOS.

    Enter BIOS

  6. Enable Hyper-V after the above has been done.

    Enable Hyper-V Manager

  7. Get Dynamic DNS (DDNS)/ Fixed WAN IP ready.

  8. If you are getting one from NO-IP, you may set it up using the client provided. Here's how.

    NO-IP Dynamic Update Client

  9. Make sure the server has Ethernet connection. (STRICTLY NO WIFI IS ALLOWED)

  10. Download and install Firebird Server.

    Firebird Downloads

  11. Make sure there is no antivirus other than Windows Defender.

  12. Fill in the checklist and send it to us.

    Checklist


Prerequisites (Detailed Information)

Network

  1. Make sure to have fiber network (not streamyx, broadband & unifi lite) / low latency internet access. (ping below 20ms)
  2. Reserve 2 IP Address: 1 for Windows & 1 for Debian virtual machine.
  3. Must have wired network connection/Ethernet.
  4. Will do port forwarding pointing towards the Debian machine as below:
    8822[WAN] : 4822[LAN]
    8122[WAN] : 22[LAN]
    
    Both entries are in TCP mode.
    NO PORT FORWARDING ON THE WINDOWS.
    
  5. Have a ready dynamic DNS (DDNS) / Fixed WAN IP Address.

Hardware

  1. CPU model not older than Intel i5 (5th generation) or AMD Ryzen 5.
  2. RAM should be at least 8GB.
  3. Make sure CPU Virtualization is enabled in the BIOS.
  4. We encourage users to switch on the PC for 24/7 so that maintenance work can be carried out without interferring users' work during work time.
  5. Must have Solid State Drive (SSD).

Operating System

  1. Windows Defender did it's job pretty well in protecting/securing your server. No third party antivirus should be installed in the server.

    Explanation:
    Third party antivirus including avast, avira, kaspersky and so on have different behavior. Each of them acts differently towards SQL Connect setup.Besides, if these antivirus update and breaks SQL Connect dependencies, it will take a long time for us to debug and resolve before your service back online. The windows antivirus (Windows Defender) has became very mature and is sufficient in securing your server.

  2. If you have used/installed serverlink in the server before, kindly reformat your server.

  3. During the setup, automatic Windows Update will be disabled. However, users still able to update by clicking on the update in the settings.
  4. SQL Connect only support Windows 10 Professional (version 1709, 1803, 1809) or Windows Server 2016 (Essential Edition and above).
    • The version mentioned above supports unlimited concurrent users.
    • Others will have a limit of 15 concurrent users login at once.
  5. Enable Hyper-V Virtualization.

    Enable Hyper-V Virtualization


SQL Connect Detector

  • SQL Connect Detector is an application for verifying/troubleshooting private cloud.
  • If you want to check if your server is eligible for setup, you may click on Examination.
  • If you have a ready private cloud server, and have issue connecting to your server, you may click on Troubleshooting to run analysis on your system.
  • You can download it from SQL Connect Detector (SQL Drive)

    SQL Connect Detector 1

Examination

  • You may enter your dynamic DNS (DDNS) / fix Public IP Address here.

    SQL Connect Detector 2

  • In the next windows, a report will show you if your server is eligible for the setup.

  • Your server is ready to setup if the report has every fields in green.
  • Suggestions will be given based on the report result.

    SQL Connect Detector 3

Troubleshooting

  • You may enter your dynamic DNS (DDNS) / fix Public IP Address here.
  • You may also change the port forwarded if you are not using the default.

    SQL Connect Detector 4

  • In the next windows, a report will show you what issue your server is facing.

  • Your server's state is healthy if the report has no field marked in red.
  • Suggestions / solutions will be given based on the report.

    SQL Connect Detector 5


Dynamic DNS (DDNS)

  1. If you don't have a DDNS, you may get one free from DuckDNS.
  2. Firstly, visit Duck DNS.

    DuckDNS 1

  3. Next, sign in using your gmail.

    DuckDNS 2

  4. Once you have sign in, you will reach the following page.

  5. Create a DDNS that you like.

    DuckDNS 3

  6. You will end up with a screen similar to the one below. Next, click on install.

    DuckDNS 4

  7. Select windows-gui, and choose the DDNS you created just now.

    DuckDNS 5

  8. A guide will be shown similar to the screen below. Follow the steps.

    DuckDNS 6

  9. Lastly, write the ddns you just created in the checklist prepared. (Ex. test-company.duckdns.org)


Troubleshooting

Bridge Network Failure

  1. Visit Control Panel > Network and Internet > Network and Sharing Center
  2. Click Change Adapter Options

    Bridge Network 1

  3. Look for adapters named Ethernet and Ethernet (Bridge)

    Bridge Network 2

  4. Right click and check the properties of each adapter.

  5. For Ethernet, it should have the following check (Example shown below):

    • Microsoft LLDP Protocol Driver
    • Hyper-V Extensible Virtual Switch

    Bridge Network 3

  6. For Ethernet (Bridge), it should be the following uncheck (Example shown below):

    • Microsoft Network Adapter Multiplexor Protocol
    • Hyper-V Extensible Virtual Switch

    Bridge Network 4


Hyper-V Service Not Running

  1. Open Services (search services in Windows search)
  2. Look for a service called Hyper-V Host Compute Service
  3. If the service status is not Running, right click and start it.

    Hyper-V Status


SQL Connect Virtual Machine Not Running

  1. Open Hyper-V Manager (search hyper-v in Windows search)

    VM Status 1

  2. Look for a virtual machine with the name SQL Connect.

  3. Make sure it's running.
  4. If it's state is some state other than running, right click on the virtual machine, and click Start.

    VM Status 2


Windows Defender Not Running

  1. If the service is not running, you have probably install third party antivirus in your server.
  2. Antivirus like Kaspersky, Avira, Avast and so on are considered as third party antivirus.
  3. These antivirus acts differently in different operation and the outcome is unpredictable.
  4. What you can do is, uninstall it and restart your server. If the issue persist after uninstall, kindly contact our dealer / support.
Back to top