# MyChild 5.x Installation Guide
# Microsoft SQL Server
# Downloading and Installing Microsoft SQL Server
### Installing & Configuring Microsoft SQL Server Express 2012
After downloading the Microsoft SQL Server Express Installer Package run it by double clicking on it.
The installer package will begin to extract files from the package. Once that has completed you will be presented with a screen as seen below.
Click the indicated link below to begin the installation!
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x1-5.png)
#### Accepting the License Terms for Microsoft SQL Server Express 2012
You will be asked to accept the License Terms. To complete this select the check box next to 'I accept the license terms.' and click next.
Note: Be sure to leave the box below that unchecked.
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x2-5.png)
#### Setting up the Product Updates for Microsoft SQL Server Express 2012
Select the check box next to 'Include SQL Server product updates', then click next.
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x3-5.png)
#### The installation of the Setup Files for Microsoft SQL Server Express 2012
Wait for the installation process to complete and click next.
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x4-5.png)
#### Microsoft SQL Server Express 2012 Feature Selection
During the SQL installation process, you will be asked to select features for the SQL Server.
Be sure to check ALL features as shown in the screen shot.
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x5-5.png)
#### Microsoft SQL Server 2012 Instance Configuration
During this phase of the installation, you will be asked to setup an instance name for the SQL Server.
The Named Instance is the name we use to connect to the SQL Server.
The default "SQLExpress" can be used.
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x6.png)
#### Microsoft SQL Server Express 2012 Server Configuration
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x7.png)
Make sure the Account Names and Startup types match the image above.
#### Microsoft SQL Server 2012 Database Engine Configuration
On this screen we need to make a few changes.
Set the Authentication Mode to
\- Mixed Mode (SQL Server Authentication and Windows Authentication)
\- Set the Password to McR0berts.1876 (Note: That is a zero)
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x8.png)
Note: Do NOT add another user unless otherwise instructed by your supervisor.
#### Microsoft SQL Server Error Reporting
Do not select anything, click next
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x9.png)
#### Installation Completed!
If everything went as expected, you should be presented with a “Complete” screen (as shown below) once on this screen, you can close the wizard and move on to the next step.
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x10.png)
# Downloading and Installing Microsoft SQL Management Studio
# Configure Microsoft SQL Server
## Configure Microsoft SQL Server 2012
#### Microsoft SQL Server 2012 External Access
Once the server is installed and running, we will need to configure the server to allow the workstations to connect and retrieve data as needed, in order to do this we need to allow TCP/IP Access via port 1433.
First we need to open the SQL Server Configuration Manager
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x11.png)
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x12-5.png)
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x13.png)
#### Restarting the Microsoft SQL Server 2012
After making the changes to the TCP/IP Ports and Settings, we need to restart the server. To do this follow the list of steps below.
Single left click on “SQL Server Services” (as seen in the image!)
Right click on SQL Server (SQLExpress) — (on the right!) Single left click “Restart”
[](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x14.png)
# MyChild Server Install
# File and Services Installation
# Configuration Files
# MyChild Workstation
# Install Files
# Setup