• Log in as this user to install the software.

• We recommend a very minimum of 2GB RAM for any machine that has SQL Server installed. 
• More RAM should be made available if the Server and POS Software are running on the same machine.
• Patch the installed SQL Server with the latest Microsoft Updates. 

Any version of SQL Server 2008 R2 is supported (Express, Standard, Enterprise etc.)

Microsoft SQL Server should be configured by persons familiar with its operation and maintenance, full support for SQL Server is beyond the scope of this manual.

SQL Server Setup

When the SQL Server is installed it should be configured to allow the TCP/IP communications protocol, using the SQL Server Configuration Manager software.

• If network PCs are not operating under Trusted Domain conditions then 'Mixed  Mode' authentication should be turned on during setup, to allow logins from remote machines.
• The Server's Firewall should be configured to allow communications over the configured TCP/IP Ports.
• Check the Protocol's properties in the SQL Server Configuration Manager to see the Active and Dynamic Ports.

The SQL Browser Service should be running when installed.

• UDP Port 1434 should be opened to allow the SQL Browser Service to listen on that port.
• Stop and Restart the SQL Server Service to allow any changes made to come into effect.
• Use the SQL Server Management Studio Tools, or the 'SQLCMD' command line tools to setup Users and Login permissions if desired.
  

When the SQL Server has been installed and tested, then the Back Office software setup can begin

• Run the eStream System 5 installation msi file supplied by your software Vendor.

Back Office Software Installation Instructions:
The following instructions apply to a default Windows 7 system with the latest service pack and 'Windows Update' patches applied.

If you are downloading the software - (If not skip these first 3 steps and just double click on the installation media or file.)

• Click 'Run' on the requester that appears after you click on the 'Download' link.
• Allow sufficient time for the download to complete.
• Click 'Run' on the requester that appears when the download has completed.

Once the software installation has downloaded and started - 

• Keep the default path displayed by the installation routine. 
• Click on the 'Next' button each time the button is displayed.
• Click the 'Close' button when the installation has completed.
• Double click the 'Back Office' icon on your desktop to start the software.

• The eStream Database has to be created or restored by the software if it does not exist already.
• Click 'Save Setup' once the connection to the Server is successful and the software sees it as being online.
• Once the Server is online then an eStream Database must exist, or be made to exist, on it.

Options for the eStream Database are: 

1. Connect to the Database Server
2. Create a New Empty Database
3. Populate the Database with Startup Data.

OR

1. Connect to the Database Server
2. Restore an Existing Backed Up Database file

OR

1. Connect to the Database Server
2. Connect to an Existing Database on the Server.

OR

1. Connect to the Database  Server
2. Create a New Empty Database
3. Import a legacy 'Jet' database from the 'Classic' version of the software.

To Connect to the Server, specify the Correct Server Name and instance, then click on the 'Test SQL Server Connection' button.

If the server is online and available, then you can continue, to Create, Restore, Upgrade or connect to a Back Office Database. 

• The options to upgrade from an older datbase or create a startup database will be available once an Empty database has been created.

• If the Database exists already, just Save the Setup and Exit the screen, the Back Office software will connect upon restart.
• If you have Created, Restored or Upgraded a database then Click, Save Setup and Exit the screen.

If you are just starting with eStream and have no Previous or older databases to upgrade or restore, then choose the option to 'Create Startup Data'

Once that is successful - exit this screen and restart the Software.

• If for any reason, an incorrectly installed database causes a problem the whole process can be repeated after the bad database has been deleted. Use the 'Delete SQL Database' button to remove ALL existing data.

Upon initial startup of any new database, including upgraded databases, you will be required to enter a License Code.

This License code is your proof of purchase of the software and will have to be set up in conjunction with your software Vendor.

• Some Reporting and Communciations functions of the Back Office are disabled if a License is not installed.
• Full support services are not available for unlicensed installations. 
• All other features of the software are fully functional for evaluation or pre-purchase data setup.

Your Name, email address, physical address and charge card information will be required to obtain a License.

The first time the software is run, a registration screen pops up which gives you a 7 Digit 'Key Information' code.
Give this Key Information to your Technical Support Team.

• Keep this Window open until you obtain the Key, as the Key Code will change each time you open it.

• Key your Business Name into the 'Business Name' box.
• If you have obtain an Activation Key from our WebSite, key it into the 'Optional Web Activation Key' box and leave the 'License Key' box blank.
• If you have obtained a Key from your Technical support team, key it into the 'License Key' box and leave the 'Web Activation Key' box blank.

Please read the license agreement and agree with the terms in it before clicking on the Check Box to install the license. 

All purchases are Final, due to the nature of software, money will not be refunded once the license has been purchased.

 
That is the last time you will have to register the program with us unless you want to install the program on another PC or re-install on a newly installed operating system.  There may be a fee for re-licensing your product, determined by the circumstances of your request. 

Make sure the Database is backed up before the software is uninstalled, or reinstalled (for any reason!) after product registration.

For further information refer to the file backup/restore section of this manual.