CSR Install

The CSR Application was developed to further assist our customers using our CERES program as well as help any potential customer with customer service.

Node.js & Code Editor Instructions

Install Visual Studio Code — https://code.visualstudio.com/
Install Node.js — https://nodejs.org/en/
Install Git — https://git-scm.com/downloads
Open Visual Studio Code.
Use the following Shortcut to open the terminal window.
```
 Ctrl + ` (Tilda is located under the esc key)
```
In the select box in the top right of the terminal window. Open the select box and then click “Select Default Shell”
Select “Git Bash” as default shell. (This may require a restart)
If it does require a restart, go ahead and restart.
If you had to restart Visual Studio Code, open the terminal window again.
```
 Ctrl + `
```
Let’s make sure Node.js is installed properly.
```
node --version
```
- if you get a response like “v12.0.0” Its installed correctly.

Configuring SQL Server Express & Management Studio

Install Microsoft SQL Server Express - https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Install MSSQL Server Management Studio - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
In the Connection Pane that loads when you first launch MSSMS (Microsoft SQL Server Management Studio)
- Under Server Name, Click ”< browse for more >”
- Click the plus button next to Database Engine and select the local instance.
- Using Windows Authentication (The Default) connect to the server.
Right Click the Database Instance name then click properties.
- Example of instance name: “PCNAME\SQLEXPRESS”
In the top left, under the options select “Security”
Under the “Server Authentication”, click the SQL Server and Windows Authentication” mode.

Under the Database Instance, open up the “Security” folder.
Right click the “Logins” folder and click “New Login”
Type In Login Name
Select SQL Server Authentication
Enter in Password and confirm it.
Uncheck the following boxes:
- Enforce Password Policy
- Enforce Password Expiration
- User Must Change Password At Next Login
Then click “Ok”

Setting Up SQL Server Browser and TCP Info

Go To The Windows Search Box and search for the following.
```
SQL Server
```
You should see an option labeled as SQL Server (Year) Configuration Manager. Open This.
- Ex: SQL Server (2017) Configuration Manager
Click the arrow to the left of “SQL Server Network Configuration Not the 32 bit option
Right click “Protocols for SQLEXPRESS” and click “Open”
Right Click TCP/IP and click “Enable”
- If it tells you changes won’t change until its restarted, you can disregard that for now. We will do that later on.
Right Click TCP/IP again and click “Properties”
At the top of the box that pops up, select the “IP Addresses” tab
Scroll all the way to the bottom of the list.
- You will see a section labeled “IPALL”
- Inside that section, type in 1433 in the TCP Port Box.
- Click apply and ok.
  - Again, if it tells you changes won’t change until its restarted disregard for now. We will do that later on.

Setting Up The Services

Look over to the menu all the way to the left. You should see a list of options:
- SQL Server Services
- SQL Server Network Configuration (32Bit)
- SQL Native Client 11.0 Configuration (32Bit)
- SQL Server Network Configuration
- SQL Native Client 11.0 Configuration
You want to right click the “SQL Server Services”and click “Open”
Right click the “SQL Server Browser” and click “properties”
At the top is 3 tabs, click the “Service” tab.
Change the “Start Mode” option to automatic
Click “Apply” and “Ok”
Right click SQL Server (SQLEXPRESS) and click “Restart” Not The Agent Option
Then right click SQL Server Browser and click “Start”

You should now be able to connect to the database with sequelize now using SQL Server Authentication.

Visual Studio Code Extensions

Bracket Pair Colorizer by CoenraadS
Auto Rename Tag by Jun Han
IntelliSense For CSS class names in HTML by Zignd
JavaScript (ES6) Code Snippets by charalampos karypidis
Live Sass Compiler by Ritwick Dey
Live Server by Ritwick Dey
Material Icon Theme by Phillipp Kief
Prettier - Code formatter by Prettier

Installing TeamViewer

Install TeamViewer Client - https://www.teamviewer.com/en-us/download/windows/
Once installed, open the application
In the top ribbon, click the “Extras” button.
- Select “Options”
- Under the general tab, click the checkbox labeled “Start TeamViewer With Windows”.
- It will prompt you for a password. Enter and confirm one.
- Click “Ok”
Now, just take note of the ID and the password you entered.
The system can now be accessed for debugging purposes.

Installing The Application Files.

Open Visual Studio Code
Open the terminal window if it did not open automatically.
```
 Ctrl + `
```
You want to navigate to the “C” drive on the machine.
Enter the following command to take you to the C drive on your computer
```
 cd C:
```
You will want to check that the changes took place, copy the following into your terminal window.
```
 pwd
```
It should read something similar to “/c”
If it doesn’t repeat step 4.

Next, copy this into your terminal and hit enter.

 git clone https://github.com/ItsYaBoyFish/CSR.git

It may ask for a password and or username to continue, if so ask Austin.
Once the files have been generated, cd into the application’s folder and type:
```
cd CSR/
```
Then type the following to install all the dependencies needed to run.
```
npm install
```
Next, install the PM2 package.
```
npm install pm2 -g
```
Now, Open The File Explorer
- Navigate to the C Drive
- Open the CSR folder
- Click the Start-CSR-Server.bat file.
The application will now run in the background. So anyone can access the application through the applications URL.

http://IP:Port/

Example: http://10.10.10.78:3000