# Downloading and Installing Microsoft SQL Server

### <span style="color: #000080;">Installing &amp; Configuring Microsoft SQL Server Express 2012</span>

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!

[![SQLInstallation5.x1.5.png](https://help.mychildcloud.com/uploads/images/gallery/2022-03/scaled-1680-/sqlinstallation5-x1-5.png)](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x1-5.png)

#### <span style="color: #003366;">Accepting the License Terms for Microsoft SQL Server Express 2012</span>

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.

<span style="background-color: #ffff00;">Note: Be sure to leave the box below that unchecked.</span>

[![SQLInstallation5.x2.5.png](https://help.mychildcloud.com/uploads/images/gallery/2022-03/scaled-1680-/sqlinstallation5-x2-5.png)](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x2-5.png)

#### <span style="color: #003366;">Setting up the Product Updates for Microsoft SQL Server Express 2012</span>

Select the check box next to 'Include SQL Server product updates', then click next.

[![SQLInstallation5.x3.5.png](https://help.mychildcloud.com/uploads/images/gallery/2022-03/scaled-1680-/sqlinstallation5-x3-5.png)](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x3-5.png)

#### <span style="color: #003366;">The installation of the Setup Files for Microsoft SQL Server Express 2012</span>

Wait for the installation process to complete and click next.

[![SQLInstallation5.x4.5.png](https://help.mychildcloud.com/uploads/images/gallery/2022-03/scaled-1680-/sqlinstallation5-x4-5.png)](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x4-5.png)

#### <span style="color: #003366;">Microsoft SQL Server Express 2012 Feature Selection</span>

During the SQL installation process, you will be asked to select features for the SQL Server.

<span style="background-color: #ffff00;">Be sure to check ALL features as shown in the screen shot. </span>

[![SQLInstallation5.x5.5.png](https://help.mychildcloud.com/uploads/images/gallery/2022-03/scaled-1680-/sqlinstallation5-x5-5.png)](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x5-5.png)

#### <span style="color: #333399;">Microsoft SQL Server 2012 Instance Configuration</span>

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.

[![SQLInstallation5.x6.png](https://help.mychildcloud.com/uploads/images/gallery/2022-03/scaled-1680-/sqlinstallation5-x6.png)](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x6.png)

#### <span style="color: #003366;">Microsoft SQL Server Express 2012 Server Configuration</span>

<span style="color: #003366;">[![SQLInstallation5.x7.png](https://help.mychildcloud.com/uploads/images/gallery/2022-03/scaled-1680-/sqlinstallation5-x7.png)](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x7.png)</span>

Make sure the Account Names and Startup types match the image above.

#### <span style="color: #003366;">Microsoft SQL Server 2012 Database Engine Configuration</span>

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 (<span style="background-color: #ffff00;">Note: That is a zero</span>)

[![SQLInstallation5.x8.png](https://help.mychildcloud.com/uploads/images/gallery/2022-03/scaled-1680-/sqlinstallation5-x8.png)](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x8.png)

<span style="background-color: #ffff00;">Note: Do NOT add another user unless otherwise instructed by your supervisor.</span>

#### <span style="color: #003366;">Microsoft SQL Server Error Reporting</span>

Do not select anything, click next

<span style="color: #003366;">[![SQLInstallation5.x9.png](https://help.mychildcloud.com/uploads/images/gallery/2022-03/scaled-1680-/sqlinstallation5-x9.png)](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x9.png)</span>

#### <span style="color: #003366;">Installation Completed!</span>

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.

<span style="color: #003366;">[![SQLInstallation5.x10.png](https://help.mychildcloud.com/uploads/images/gallery/2022-03/scaled-1680-/sqlinstallation5-x10.png)](https://help.mychildcloud.com/uploads/images/gallery/2022-03/sqlinstallation5-x10.png)</span>