sql-accounting-logo.png
  • Products & Services

    • SQL Account
    • SQL Cloud Hosting
    • E-Invoicing
    • Free Trial
  • Promotion

  • Grant

    • PSG Grant for SQL Account
    • SFEC Grant
    • How to Submit PSG Grant for SQL Account
  • Learn & Support

    • Business Support
    • User Guide
    • Tutorial Video
  • About Us

  • Contact Us

  • More

    Use tab to navigate through the menu items.
    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    Agnes Lee
    Aug 03, 2017
      ·  Edited: Aug 03, 2017

    Network Setting

    in Getting Started

    Learn how to setup SQL Account in a multi-user environment.


    Server PC Setting


    Step 1: Install Firebird Version

    Visit http://www.sql.com.my/support/downloads to download the firebird version.

    (Depending if your Windows System type is 32 bits or 64 bits.)


    Run Firebird setup.

    1. Press OK.

    2. Select I accept the agreement.

    3. Click 5 times Next.

    4. Make sure Run Firebird in SuperServer mode is selected. Press Next.

    5. Leave the SYSDBA password blank. Press Next.

    6. Press Install > Next > Finish.


    Step 2: Window Firewall

    Open Control Panel.

    1. Select Window Firewall > Advanced Setting > Inbound Rules > New Rules.

    2. Select Port > Next > TCP > Specific Local port = 3050 > Next 3 times.

    3. Name = Firebird > Finish.


    Step 3: Network and Sharing Centre

    Open Control Panel.

    1. Select Network and Sharing Center > Change Advanced Sharing Setting.

    2. Turn On Network Discovery.

    3. Turn On File and Printer Sharing.

    4. Turn On Public Folder Sharing.

    5. Turn On File Sharing Connection. Use 128-bit encryption to help protect file sharing connections (recommended).

    6. Turn Off Password Protected Sharing.


    Step 5: Share SQL Account Folder

    Open My Computer.

    1. Go to C:\eStream\SQLAccounting\Share

    2. Right click on the Share folder > Select Properties > Sharing > Advanced Sharing > Select Share this folder > Select Permissions > Tick Full Control > Press OK 2 times.

    3. Click on Security > Advanced > Change Permissions > Add > Everyone > Press OK > Tick Allow Full Control > Press OK 4 times.


    Step 5: Install SQL Account

    Run SQL Account installer and use the default settings.

    1. Open SQL Account > Choose Advanced.

    2. Create Group > Click DCF Group > Click Save.

    3. Change Database Engine to Firebird Server.

    4. Test Connection > OK.


    Client PC Setting

    Install SQL Account at user PC and use the default settings.

    1. Open SQL Account > Choose Advanced.

    2. Add Group > Select the Share Folder being shared from Server PC.

    3. Select Default.DCF file > Open.

    4. Double click on the Firebird icon and proceed to login.

    0 comments
    Closed
    0
    Closed
    0 comments
    Apscom Solutions Logo.png

    7 Gambas Crescent

    #05-11 ARK @ Gambas

    Singapore 757087

    Our passion is to help you transform your business with the best accounting software & solutions for your company with long-term improvement!

    Contact

    ​

    Carol Kok

    +65 97206813

    ​

    Agnes Lee

    +65 65130695

    ​

    sales@sqlaccounting.sg

    © 2022 Apscom Solutions. All Rights Reserved.

    Best in Singapore Badge.jpeg
    sql accounting apscom.png