Network Setting

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

Server PC Setting

Step 1: Install Firebird Version

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