Agnes Lee
Aug 3, 2017
Edited: Aug 3, 2017

Network Setting

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.

Closed
Closed