If you have a very small restaurant, you may use MSDE as your database server, otherwise pick MS SQL server. MSDE is free to download, it save some money for you. Click here to download MSDE，unpack the file to a directory say MSDERelA, open Readme.htm for more information. Click Start/Run，in Run dialog enter command as below:

c:/MSDERelA/setup.exe SAPWD=password SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

Where c:/MSDERelA is the directory which MSDE is unpack to. Replace password with your password and write it down, you will need this password later, keeping SECURITYMODE= SQL DISABLENETWORKPROTOCOLS=0 unchanged.

Example:

if MSDE is unpacked in directory "c:\MSDERelA\" and use "sample" as your password 
in run dialog enter  "c:\MSDERelA\setup.exe SAPWD=sample SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0"

When setting config.txt later, set user id=sa, password=sample

B3. Installing MS .NET Framework 1.1

Please click here to Download MS .Net Framework 1.1, follow the instruction to compete the installation.

B4. Installing KeyFour Restaurant

1. Unzip the package use WinZip，browse the directory using file explorer and double click setup.exe, follow the instructions to complete the installation. Please remember never change the default virtual directory name "Restaurant_en" during installation. 

2. Setting config.txt

Config.txt is located in directory "C:\Inetpub\wwwroot\Restaurant_en\System" typically; exact location depends on your system, sometime it maybe different. After making changes in config.txt，you must restart your computer in order to make the new settings take effect. You must protect this file from reading by others other than the users of this machine. Right click config.txt, select property, and hide the file by placing a check on the check box. Click Security tag, select Internet User, and deny reading by placing a check on read as the diagram shown below.

Config.txt Any line starting with # is used for common. Single one line cannot be broken into two lines.

AgentID Agent ID

SystemName The name of your restaurant

PageSize : 10  Number of lines per pages

PerSet : 10  Number of pages

Columns : 3  How many columns for the menu to be displayed, value can be 1-4

Pocket_Columns : 1   How many columns for the menu to be displayed on Pocket PCs, value can 1-4

TableColumns : 3   How many columns for change table page, value can be 1-5

Pocket_TableColumns : 2   How many columns for change table page for Pocket PCs, value can be 1-5

Refresh_Period : 60  Kitchen page refresh period, the number is in seconds, the default is 60 seconds.

Connection_String : server=(local);database=Restaurant;UserId=sa;Password=sample;Trusted_connection=no

Connection_String is very long, but is one line, never break it into two lines. Normally, you don't have the setting, but if you set the password different than "sample", change it accordingly.

3. Creating Database:
You must create a database before using the system. In IE Address window enter
http://localhost/Restaurant_en/Common/CreateDatabase.aspx bring up the page as below, here localhost can be replaced by the machine name or the machine's IP address。

* For some reasons, both deleting and creating database may fail, if this is the case, try shut down and restart the database server and try again. If creating database fail in the middle of creation, you have to delete the database and create it again.

If both MSDE and IIS are installed on the same machine, database server name can use "(local)" or use the machine name. If use "Use Window authentication", no User ID and password are needed, otherwise, you must enter User ID and Password. In our example, User ID is sa and Password is sample. Click "Create Database" to create the database. 

After database creation has completed, you must restart your machine.

4. Start the System:

In server machine's IE address window enter http://localhost/Restaurant_en/Common/home.aspx 
In other machines' IE address windows enter http://ServerName/Restaurant_en/Common/home.aspx where ServerName is the machine name or domain name of the machine.