CERES Install

This is a step by step guide to installing CERES for a Customer Site

Installs

1. Install SQL Express on the machine locally. (Unless asked otherwise)
2. Install Microsoft SQL Server Management Studio
3. Install Team Viewer on the machine.
4. Install Git on the machine. Click Here For Install

Configuring SQL Server For Production

TODO

• This includes setting up logins
• Make inboud rules for the following
  • Open firewall and go to Advanced Settings.
    • Set Inbound Rule For the SQL Server Program
    • Set Inbound Rule For UDP Port 1434
    • Here is a reference if you need it.

Downloading Project Files

5. Next, we are going to get the CERES project files. The files contain a SQL Script you can run to setup the databases and there structures.

6. Open Git Bash (Windows key and search for it if its not on the desktop)

7. Type this command to take you to the C drive on your computer

cd C:

8. Next, we are going to pull down the latest version of CERES

git clone https://github.com/CE-LLC/CERES.git

9. You can now close Git Bash
10. Open your windows file explorer and navigate to the CERES Directory and open it

  C:/CERES

11. In case it isn’t already open, open Microsoft SQL Server Management Studio now.

Setting up SQL Database Structures

12. In the CERES Directory, open the Installs folder and then open the SQL Scripts folder. Inside you will find a file labeled CERES Startup.sql. Drag and drop that file into Microsoft SQL Server Management Studio.
13. Once the page loads, go ahead and execute the sql file. This will set everything up for you. (It may take several seconds)