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.
Press OK.
Select I accept the agreement.
Click 5 times Next.
Make sure Run Firebird in SuperServer mode is selected. Press Next.
Leave the SYSDBA password blank. Press Next.
Press Install > Next > Finish.
Step 2: Window Firewall
Open Control Panel.
Select Window Firewall > Advanced Setting > Inbound Rules > New Rules.
Select Port > Next > TCP > Specific Local port = 3050 > Next 3 times.
Name = Firebird > Finish.
Step 3: Network and Sharing Centre
Open Control Panel.
Select Network and Sharing Center > Change Advanced Sharing Setting.
Turn On Network Discovery.
Turn On File and Printer Sharing.
Turn On Public Folder Sharing.
Turn On File Sharing Connection. Use 128-bit encryption to help protect file sharing connections (recommended).
Turn Off Password Protected Sharing.
Step 5: Share SQL Account Folder
Open My Computer.
Go to C:\eStream\SQLAccounting\Share
Right click on the Share folder > Select Properties > Sharing > Advanced Sharing > Select Share this folder > Select Permissions > Tick Full Control > Press OK 2 times.
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.
Open SQL Account > Choose Advanced.
Create Group > Click DCF Group > Click Save.
Change Database Engine to Firebird Server.
Test Connection > OK.
Client PC Setting
Install SQL Account at user PC and use the default settings.
Open SQL Account > Choose Advanced.
Add Group > Select the Share Folder being shared from Server PC.
Select Default.DCF file > Open.
Double click on the Firebird icon and proceed to login.