The EBMS Server module of EBMS is used primarily to manufacture products or create assemblies to distribute or sell. The amount of inventory items are increased using the manufacturing process rather than by purchasing items through an expense invoice. This module should be used in the following situations:
The EBMS Server is optional software that is recommended for companies with 10 or more users or 7 or more concurrent users.
The EBMS Server is an application that runs as a service on a Windows- based server such as Windows 2000. All file access functions are managed by the Server software running on the application server which allows the clients to request specific information from the server rather than opening, sorting, and indexing the files individually.
EBMS client/server offers many advantages over the standard networked model of database access:
Scalability - The client/server application allows EBMS to scale to 50 users.
Stability - Because the database server is the only application that implements changes to the database, the risk of database damage and corrupted indexes are greatly reduced.
Performance - In any situation where limited bandwidth can affect program performance, client/server can speed database operations by significantly reducing network traffic. Running a server on a high-performance computer also improves overall performance by letting client applications take advantage of the server's inherent processing speed. Eagle Solutions recommends that the client/server application is implemented on a Windows 2000 Server when EBMS is used with more than 5 simultaneous users.
Data Integrity - EBMS will roll back any partially created transactions if a power outage, network failure, or other interruption aborts a process such as processing invoices, timecards, payments, or writing any information. If the server has not received all transactions within a process, the server ignores the entire set of transactions. This ensures that the large volume of data maintained by EBMS does not become mismatched.
Large File Size - the size of database files will increase from 2.7gig for a single file to 4.2 billion gigabytes (virtually unlimited).
Security - The EBMS server helps the user secure company data even better. Files do not need to be shared. The only way to access the data on the network is by logging on the server. Communications with the server are encrypted. In addition to basic account information, you can also specify an IP address range for any account. If the account doesn't log in from a machine within the specified range, access is denied.
We've also added some great new features to the EBMS client/server configuration:
Easy Server Configuration - EBMS 6.5 makes it much easier for the administrator and the end-users to configure and maintain the EBMS information store. All server configuration options can be accessed through the EBMS Administrator application.
Information Reporting -The EBMS server can supply reports on a variety of information to help the administrator manage the client/server applications. The reporting enhancements include:
o Server Information - Provides general information on server up-time, number of users connected and more.
o Account Reports - Provides details on all current server accounts, including account-level file privileges and any IP address restrictions.
o Privilege Reports - Provides a list of all individual account/table privileges recognized by the EBMS server.
o Connection Information - Provides you with a number of different reports that detail which accounts are currently connected to the EBMS server, which tables each account is using and what table/record locks each account has in place, useful both for security reasons and when troubleshooting applications.
All server reports can be accessed easily through the EBMS server administrator.
The EBMS server software requires the following:
· Windows 2003 Server (recommended for multi-function servers with over 10 users)
· Windows 2000 Server
· Windows XP Professional
· 512MB of RAM required, 1Gig of Ram recommended
· 2 GIG Hard disk space recommended
The machine that is running EBMS server should be dedicated to data sharing and not be used as a workstation.
The instructions in the section are only applicable to install the Server version of the system. Skip this section and go to the previous installation section (Installing EBMS on a Network) if EBMS is setup in a peer environment (Not client server).
2. Run Start > Programs > Eagle Business Management > Company Administrator.
The following dialog will appear:
Enter a path where you want to store security and company settings. The path should then be secured with windows network security to prevent unauthorized persons from accessing passwords and security information. Note that the "System" account will need full access to this folder.
Press OK and create the folder and the following dialog will appear:
Click the New button. You will need to select one of the following options:
Select Connect to an existing company to connect to a company that already exists. In the next step you will be prompted to enter a data path and a report path. See below. Note that you should not use redirected drive letters. Use the drive letter that represents the local drive ("My Computer" shows these drives as "Local Disk").
Select New Company if you want to create data for a new company. In the next step you will be prompted to enter a data path and a report path. This is where your new company data will be stored. Be sure to include these folders in your backup.
Company Id - Enter a 3 character ID.
Data Path - Enter the path for the company data.
Company Name - Enter your company name.
Press OK. The server is now set up. You will need to install the EBMS program on all the workstation computers.
This optional EBMS module is not included on all versions of the EBMS software. Review the Features > Optional EBMS modules within the main software manual for specific instructions used to identify or add optional modules.