Sql-installation & Network Setup
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Sql-installation & Network Setup as PDF for free.
More details
- Words: 1,934
- Pages: 28
e
SQL-Installation & Network Setup eStream Software
SQL Installation & Network Setup
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page i
e
SQL-Installation & Network Setup eStream Software Table of contents
1 INTRODUCTION...............................................................................................2 2 INSTALLATION FIREBIRD DATABASE SERVER..........................................2 2.1 Insert SQL Accounting CD.........................................................................2 2.2 Firebird Database Server Installation Wizard..........................................3 2.3 To check Firebird Engine Started..............................................................8 3 HOW TO INSTALL SQL ACCOUNTING INTO SERVER?...............................9 3.1 Insert SQL Accounting CD.........................................................................9 3.2 SQL Accounting Installation Wizard.........................................................9 4 OTHER SETTING IN WINDOWS....................................................................13 4.1 Share Estream Folder...............................................................................13 4.2 Windows Firewall Setting........................................................................15 5 SQL ACCOUNTING SETTING IN NETWORK...............................................17 5.1 Choose Working Environment................................................................17 5.2 Choose Database Collection File (DCF) Option....................................17 5.3 Select Database Server............................................................................18 5.4 Define Account Book Manager................................................................19 5.5 Create New Database...............................................................................22 5.6 SQL Accounting Logon............................................................................24 6 SQL ACCOUNTS CLIENT SETUP.................................................................24 6.1 SQL Accounting Installation....................................................................24 6.2 Client PC Account Book Manager Setting.............................................24 7 POSSIBILITY WARNING MESSAGE.............................................................26 7.1.1 Failed to locate Default Database Collection File (DCF) “C:\Program Files\eStream\SQLAccounting\Default .DCF”....................................................... ..........26
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page ii
SQL-Installation & Network Setup eStream Software VERSION CONTROL Version No. 1.0
Date 10 Aug 2006
Author / Compiled by Document name Date (last modified)
: : :
Initiated by Loo Chin Soon
Loo 8631865.doc
Remarks Initial document
Page 1
SQL-Installation & Network Setup eStream Software 1
INTRODUCTION This guide will teach you on the new setup for SQL Accounting in a network environment.
2
INSTALLATION FIREBIRD DATABASE SERVER 2.1 Insert SQL Accounting CD You must install the Firebird Engine in order to run SQL Accounting in network mode. Click on Firebird button as circled in below screen.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 2
SQL-Installation & Network Setup eStream Software 2.2 Firebird Database Server Installation Wizard 1) You must install the Firebird Engine in order to run SQL Accounting in network environment.
2) You will see below License Agreement. Please read it and accept the agreement before proceed to NEXT.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 3
SQL-Installation & Network Setup eStream Software 3) Click NEXT to proceed.
4) Leave it as default and click on NEXT to proceed.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 4
SQL-Installation & Network Setup eStream Software 5) Leave it as default and click on NEXT to proceed.
6) Leave it as default and click on NEXT.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 5
SQL-Installation & Network Setup eStream Software 7) Leave it as default (DO NOT CHANGE THE SETTING HERE). Click NEXT to proceed.
8) Click INSTALL to start installation.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 6
SQL-Installation & Network Setup eStream Software 9) Just click NEXT.
10) Click FINISH to end the installation.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 7
SQL-Installation & Network Setup eStream Software 2.3 To check Firebird Engine Started Go to control panel and you will find the Firebird 1.5 Server Manager as show screen below. Double click and check the status.
Just make sure the Firebird service is running.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 8
SQL-Installation & Network Setup eStream Software 3
HOW TO INSTALL SQL ACCOUNTING INTO SERVER? 3.1 Insert SQL Accounting CD After you have insert the SQL Accounting CD into the server, .you will see the following screen appeared. You have to point to SQL Account and click on “Install SQL Accounting (Version XXXXXXX)”.
3.2 SQL Accounting Installation Wizard 1) You have to wait below screen process finished.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 9
SQL-Installation & Network Setup eStream Software 2) Click NEXT to proceed.
3) You will see below License Agreement. Please read it and accept the agreement before proceed to NEXT.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 10
SQL-Installation & Network Setup eStream Software 4) Leave it default and click on NEXT.
5) Leave it default and click on NEXT.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 11
SQL-Installation & Network Setup eStream Software 6) Review and confirm the setting by click INSTALL to start installation.
7) Click FINISH to finish the installation.
8) You can see a shortcut icon created in your PC desktop.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 12
SQL-Installation & Network Setup eStream Software 4
OTHER SETTING IN WINDOWS 4.1 Share Estream Folder You need to share-out the Estream folder in Program Files. This is to enable other PC client to access the database file in server. Right click on the Estream folder and select “Sharing and Security …”.
Then you will get the following screen, so you must tick both:a) Share this folder on the network. b) Allow network users to change my files.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 13
SQL-Installation & Network Setup eStream Software
T ick
You will found that the Estream folder will shared out (a hand hold the folder) as below screen.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 14
SQL-Installation & Network Setup eStream Software 4.2 Windows Firewall Setting 1) Go to control panel and double click on Windows Firewall.
2) You will see the following screen prompted. By default is “ON”.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 15
SQL-Installation & Network Setup eStream Software 3) Go to Exception tab and click on “Add Port…” button.
4) Follow the below info in the screen below, then click OK button.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 16
SQL-Installation & Network Setup eStream Software 5
SQL ACCOUNTING SETTING IN NETWORK 5.1 Choose Working Environment Please choose an appropriate working environment. a) Standalone b) Network Choose an appropriate environment
5.2 Choose Database Collection File (DCF) Option For first time installation, please choose ‘Create New DCF’ option and click OK to proceed.
You have to input “Default” as the filename for DCF under C:\Program Files\Estream\SQLAccounting and SAVE it.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 17
SQL-Installation & Network Setup eStream Software NOTE: If you have created the DCF file, you may choose second option, ie. ‘Open Existing DCF’.
5.3 Select Database Server For network setting, you must choose the Firebird 1.5 Server. Below is the list of options available: a) Standalone Server (Recommended for single PC) b) Firebird 1.5 Server (Recommended for network environment) c) Firebird 1.0 Server (Not recommended) d) Interbase 6.0 Server (Not recommended) e) Interbase 7.1 Server (Not recommended) f) Microsoft SQL Server 2000 (Coming Soon) g) Oracle Server (Not applicable)
Note: You must install the Firebird Database Server. For more detail about installation, please refer to Chapter 2 : INSTALLATION FIREBIRD DATABASE SERVER.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 18
SQL-Installation & Network Setup eStream Software 5.4 Define Account Book Manager 1) Click on ‘Firebird 1.5 Server Properties…’ in Account Book Manager window.
2) You will see below screen appeared. For network, please choose option-Remote (TCP/IP Network). Otherwise, choose option-Local (Standalone PC).
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 19
SQL-Installation & Network Setup eStream Software 3) Once you have selected option- Remote (TCP/IP Network), you will get a confirmation for the Server IP Address message as show below.
4) After that, click on TEST Connection button.
This test connection will prompt you different status depends on the test connection results. Possible status: a) Status: Connection Active Server Version: WI-V1.5.1.4481 Firebird 1.5 b) Status: Unknown. It will prompted you the below message, so you have to make sure: ♦ Server is connected in network environment. ♦ Server IP address is correct. ♦ Firebird Database Server Engine is started.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 20
SQL-Installation & Network Setup eStream Software 5) Next, you have to define the path in Folder Setting correctly and carefully. Click on the open folder button to define it. a) Database Folder: C:\Program Files\eStream\SQLAccounting\DB b) Server Backup Folder: C:\Program Files\eStream\SQLAccounting\Backup c) Network Backup Folder: \\**ServerName\eStream\SQLAccounting\Backup **ServerName: Make sure choose the correct server.
Please do click on ‘Test Backup Folder Accessibility’ to check the status. Possible status: a) Status: You have acess to backup folder. (Correct) b) Status: You don’t have enough access right to backup folder. (Incorrect. You have to check the share folder access right.) c) Status: Network backup folder and Server backup folder are not in same physical folder. (Incorrect. Make sure both backup folders are point to same source.) Tips: If you get the below warning message, just click OK to continue.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 21
SQL-Installation & Network Setup eStream Software 5.5 Create New Database 1) Click on NEW button and select ‘Create New Database’ to create new database. There are some options: a) Evaluation with Sample Data… b) Create New Database… c) Restore From Backup…
2) You will get below message. Just click OK to proceed.
3) Please specify a new database file name. DO NOT change it, just leave as default. Click OK to proceed.
4) You will get the below message that new database created.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 22
SQL-Installation & Network Setup eStream Software 5) You will see a New Company added into database list as shown below.
6) Click on CLOSE button to exit the Account Book Manager. If you have get the below message, please click Yes.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 23
SQL-Installation & Network Setup eStream Software 5.6 SQL Accounting Logon After close the Account Book Manager, you will prompted LOGON screen. First time login as: User: ADMIN Password: ADMIN
6
SQL ACCOUNTS CLIENT SETUP 6.1 SQL Accounting Installation Refer to Chapter 3: How to Install SQL Accounting into Server.
6.2 Client PC Account Book Manager Setting 1) For client PC, please select Network and click OK.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 24
SQL-Installation & Network Setup eStream Software 2) Please select ‘Open Existing DCF’ and click OK to proceed.
3) Browse thru ‘My Network Place Entire Microsoft Windows Network WorkGroup or your domain’ and select the server name. From this stage, you will see the sharing folder (eStream\SQLAccounting).Select and OPEN the ‘DEFAULT.DCF’ file.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 25
SQL-Installation & Network Setup eStream Software 7
POSSIBILITY WARNING MESSAGE
7.1.1
Failed to locate Default Database Collection File (DCF) “C:\Program Files\eStream\SQLAccounting\Default .DCF”.
If you get the above message, please do the following checking: a) Make sure the Server or Workstation PC is connected in network environment; or b) Make sure the ‘DEFAULT.DCF’ file is under correct directory in the server.
<<END>>
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 26
SQL-Installation & Network Setup eStream Software
SQL Installation & Network Setup
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page i
e
SQL-Installation & Network Setup eStream Software Table of contents
1 INTRODUCTION...............................................................................................2 2 INSTALLATION FIREBIRD DATABASE SERVER..........................................2 2.1 Insert SQL Accounting CD.........................................................................2 2.2 Firebird Database Server Installation Wizard..........................................3 2.3 To check Firebird Engine Started..............................................................8 3 HOW TO INSTALL SQL ACCOUNTING INTO SERVER?...............................9 3.1 Insert SQL Accounting CD.........................................................................9 3.2 SQL Accounting Installation Wizard.........................................................9 4 OTHER SETTING IN WINDOWS....................................................................13 4.1 Share Estream Folder...............................................................................13 4.2 Windows Firewall Setting........................................................................15 5 SQL ACCOUNTING SETTING IN NETWORK...............................................17 5.1 Choose Working Environment................................................................17 5.2 Choose Database Collection File (DCF) Option....................................17 5.3 Select Database Server............................................................................18 5.4 Define Account Book Manager................................................................19 5.5 Create New Database...............................................................................22 5.6 SQL Accounting Logon............................................................................24 6 SQL ACCOUNTS CLIENT SETUP.................................................................24 6.1 SQL Accounting Installation....................................................................24 6.2 Client PC Account Book Manager Setting.............................................24 7 POSSIBILITY WARNING MESSAGE.............................................................26 7.1.1 Failed to locate Default Database Collection File (DCF) “C:\Program Files\eStream\SQLAccounting\Default .DCF”....................................................... ..........26
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page ii
SQL-Installation & Network Setup eStream Software VERSION CONTROL Version No. 1.0
Date 10 Aug 2006
Author / Compiled by Document name Date (last modified)
: : :
Initiated by Loo Chin Soon
Loo 8631865.doc
Remarks Initial document
Page 1
SQL-Installation & Network Setup eStream Software 1
INTRODUCTION This guide will teach you on the new setup for SQL Accounting in a network environment.
2
INSTALLATION FIREBIRD DATABASE SERVER 2.1 Insert SQL Accounting CD You must install the Firebird Engine in order to run SQL Accounting in network mode. Click on Firebird button as circled in below screen.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 2
SQL-Installation & Network Setup eStream Software 2.2 Firebird Database Server Installation Wizard 1) You must install the Firebird Engine in order to run SQL Accounting in network environment.
2) You will see below License Agreement. Please read it and accept the agreement before proceed to NEXT.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 3
SQL-Installation & Network Setup eStream Software 3) Click NEXT to proceed.
4) Leave it as default and click on NEXT to proceed.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 4
SQL-Installation & Network Setup eStream Software 5) Leave it as default and click on NEXT to proceed.
6) Leave it as default and click on NEXT.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 5
SQL-Installation & Network Setup eStream Software 7) Leave it as default (DO NOT CHANGE THE SETTING HERE). Click NEXT to proceed.
8) Click INSTALL to start installation.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 6
SQL-Installation & Network Setup eStream Software 9) Just click NEXT.
10) Click FINISH to end the installation.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 7
SQL-Installation & Network Setup eStream Software 2.3 To check Firebird Engine Started Go to control panel and you will find the Firebird 1.5 Server Manager as show screen below. Double click and check the status.
Just make sure the Firebird service is running.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 8
SQL-Installation & Network Setup eStream Software 3
HOW TO INSTALL SQL ACCOUNTING INTO SERVER? 3.1 Insert SQL Accounting CD After you have insert the SQL Accounting CD into the server, .you will see the following screen appeared. You have to point to SQL Account and click on “Install SQL Accounting (Version XXXXXXX)”.
3.2 SQL Accounting Installation Wizard 1) You have to wait below screen process finished.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 9
SQL-Installation & Network Setup eStream Software 2) Click NEXT to proceed.
3) You will see below License Agreement. Please read it and accept the agreement before proceed to NEXT.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 10
SQL-Installation & Network Setup eStream Software 4) Leave it default and click on NEXT.
5) Leave it default and click on NEXT.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 11
SQL-Installation & Network Setup eStream Software 6) Review and confirm the setting by click INSTALL to start installation.
7) Click FINISH to finish the installation.
8) You can see a shortcut icon created in your PC desktop.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 12
SQL-Installation & Network Setup eStream Software 4
OTHER SETTING IN WINDOWS 4.1 Share Estream Folder You need to share-out the Estream folder in Program Files. This is to enable other PC client to access the database file in server. Right click on the Estream folder and select “Sharing and Security …”.
Then you will get the following screen, so you must tick both:a) Share this folder on the network. b) Allow network users to change my files.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 13
SQL-Installation & Network Setup eStream Software
T ick
You will found that the Estream folder will shared out (a hand hold the folder) as below screen.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 14
SQL-Installation & Network Setup eStream Software 4.2 Windows Firewall Setting 1) Go to control panel and double click on Windows Firewall.
2) You will see the following screen prompted. By default is “ON”.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 15
SQL-Installation & Network Setup eStream Software 3) Go to Exception tab and click on “Add Port…” button.
4) Follow the below info in the screen below, then click OK button.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 16
SQL-Installation & Network Setup eStream Software 5
SQL ACCOUNTING SETTING IN NETWORK 5.1 Choose Working Environment Please choose an appropriate working environment. a) Standalone b) Network Choose an appropriate environment
5.2 Choose Database Collection File (DCF) Option For first time installation, please choose ‘Create New DCF’ option and click OK to proceed.
You have to input “Default” as the filename for DCF under C:\Program Files\Estream\SQLAccounting and SAVE it.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 17
SQL-Installation & Network Setup eStream Software NOTE: If you have created the DCF file, you may choose second option, ie. ‘Open Existing DCF’.
5.3 Select Database Server For network setting, you must choose the Firebird 1.5 Server. Below is the list of options available: a) Standalone Server (Recommended for single PC) b) Firebird 1.5 Server (Recommended for network environment) c) Firebird 1.0 Server (Not recommended) d) Interbase 6.0 Server (Not recommended) e) Interbase 7.1 Server (Not recommended) f) Microsoft SQL Server 2000 (Coming Soon) g) Oracle Server (Not applicable)
Note: You must install the Firebird Database Server. For more detail about installation, please refer to Chapter 2 : INSTALLATION FIREBIRD DATABASE SERVER.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 18
SQL-Installation & Network Setup eStream Software 5.4 Define Account Book Manager 1) Click on ‘Firebird 1.5 Server Properties…’ in Account Book Manager window.
2) You will see below screen appeared. For network, please choose option-Remote (TCP/IP Network). Otherwise, choose option-Local (Standalone PC).
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 19
SQL-Installation & Network Setup eStream Software 3) Once you have selected option- Remote (TCP/IP Network), you will get a confirmation for the Server IP Address message as show below.
4) After that, click on TEST Connection button.
This test connection will prompt you different status depends on the test connection results. Possible status: a) Status: Connection Active Server Version: WI-V1.5.1.4481 Firebird 1.5 b) Status: Unknown. It will prompted you the below message, so you have to make sure: ♦ Server is connected in network environment. ♦ Server IP address is correct. ♦ Firebird Database Server Engine is started.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 20
SQL-Installation & Network Setup eStream Software 5) Next, you have to define the path in Folder Setting correctly and carefully. Click on the open folder button to define it. a) Database Folder: C:\Program Files\eStream\SQLAccounting\DB b) Server Backup Folder: C:\Program Files\eStream\SQLAccounting\Backup c) Network Backup Folder: \\**ServerName\eStream\SQLAccounting\Backup **ServerName: Make sure choose the correct server.
Please do click on ‘Test Backup Folder Accessibility’ to check the status. Possible status: a) Status: You have acess to backup folder. (Correct) b) Status: You don’t have enough access right to backup folder. (Incorrect. You have to check the share folder access right.) c) Status: Network backup folder and Server backup folder are not in same physical folder. (Incorrect. Make sure both backup folders are point to same source.) Tips: If you get the below warning message, just click OK to continue.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 21
SQL-Installation & Network Setup eStream Software 5.5 Create New Database 1) Click on NEW button and select ‘Create New Database’ to create new database. There are some options: a) Evaluation with Sample Data… b) Create New Database… c) Restore From Backup…
2) You will get below message. Just click OK to proceed.
3) Please specify a new database file name. DO NOT change it, just leave as default. Click OK to proceed.
4) You will get the below message that new database created.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 22
SQL-Installation & Network Setup eStream Software 5) You will see a New Company added into database list as shown below.
6) Click on CLOSE button to exit the Account Book Manager. If you have get the below message, please click Yes.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 23
SQL-Installation & Network Setup eStream Software 5.6 SQL Accounting Logon After close the Account Book Manager, you will prompted LOGON screen. First time login as: User: ADMIN Password: ADMIN
6
SQL ACCOUNTS CLIENT SETUP 6.1 SQL Accounting Installation Refer to Chapter 3: How to Install SQL Accounting into Server.
6.2 Client PC Account Book Manager Setting 1) For client PC, please select Network and click OK.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 24
SQL-Installation & Network Setup eStream Software 2) Please select ‘Open Existing DCF’ and click OK to proceed.
3) Browse thru ‘My Network Place Entire Microsoft Windows Network WorkGroup or your domain’ and select the server name. From this stage, you will see the sharing folder (eStream\SQLAccounting).Select and OPEN the ‘DEFAULT.DCF’ file.
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 25
SQL-Installation & Network Setup eStream Software 7
POSSIBILITY WARNING MESSAGE
7.1.1
Failed to locate Default Database Collection File (DCF) “C:\Program Files\eStream\SQLAccounting\Default .DCF”.
If you get the above message, please do the following checking: a) Make sure the Server or Workstation PC is connected in network environment; or b) Make sure the ‘DEFAULT.DCF’ file is under correct directory in the server.
<<END>>
Author / Compiled by Document name Date (last modified)
: : :
Loo 8631865.doc
Page 26
Related Documents
Abc Network Setup Security
May 2020 7
Setup+huawei+dialup+network
June 2020 6
Sql-installation & Network Setup
October 2019 17
How To Setup Network Basics
November 2019 29
Setup
November 2019 17